Query using 'LIKE'

[jamesguffey3]

I'm trying to use SOAP SelectDataRaw call to query my table and I want to use "LIKE" in the criteria section but I'm not able to. Criteria would be similar to:

Name LIKE 'jame' 

to get result "James" (where yes, James is in the table). I've tried:

Name LIKE 'jame'

Name LIKE '*jame*'

Name LIKE *jame*

 

How do I query the table to return results where only a portion of the field need be identified???

 

[jamesguffey3]

OK - I'm used to using * as the wildcard, but it's %. There you go for future reference...