QUERY TO LOCATE SPACES

[100dtl]

Hi all,

I want to get data back dependant on a row have two words

ie: 'Under Research' so i want the get the column data back if there is a space again this could change to
'X21 X25 X703'

 

[mrdenny]

If you want any record that has a space in it then

select *
from tablename
where columnname like '% %'

See select in BOL.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[100dtl]

Super,