Like Command 1

[WJProctor]

Hi there, im writting a search facility on one on my programs, and i want the user to be able to search but not have to type on the full search value. I seem to think before ive used the like command, but its doesnt seem to work. Whats the actual syntax for this statement?

Hope someone can help

JP

 

[Golom]

The LIKE operator is used like this

   Where FieldName LIKE '%ABC%'

where '%' matches any characters (zero or more) and '_' matches a single character.

 

[WJProctor]

Thanks, thats really clear, cheers for your help.

JP