Can someone supply me with the syntax that will generate a seven (7)character string that includes only the following characters? 0, #, *, @, X, P, F, 1-9 Thanks, Courday MS Sql Server LazyDBA home page