Shoutbox

Is it possible to have a WHERE clause in an SQL statement to check if a field contains a certain string?

There is a field that contains 3 to 4 numbers, a dot, then some more numbers, eg:

234.456
1345.123
234.004
931.631

How can I retrive just the records that have 234. as the first section?  Can you check for parts of a field in a WHERE clause?

WHERE field  LIKE '234%'

something like that would work

didn't think it would be that simple, cheers -dt-