Cool! :) >It'll do but for me >where B.EONO LIKE '[0-9]%' >looks more 'SQL like' :) > > >>What about this? >>substring(d.eono,1,1) between "0" and "9") > >> >>>>Will it work for the first character? > >>>>>Is this better? >>>>>
>>>>>where B.EONO LIKE'[0-9]%'
>>>>>
>>> >>>Yes it will. Take a look at LIKE operator in SQL Server BOL.
