SQL to detect spaces in the data

[shaan1980]

I want to a creata query for that returns data items that contain a space.

for example id='9 0'

I am using a sybase database.

[syber]

WHERE id LIKE '% %'