Search string within field

[denko]

I have a query that uses "Like" keyword.

Select Field1, Field2
from Table1
Where (Table1.Field1) Like "*CL B"

I do not really like that syntax, can someone tell me what function I can use instead. I tried InStr but it did not work, or maybe I did not use it properly, not sure.
Thanks

 

[mgolla]

Did your InStr look like this?

InStr(4, Table1.Field1,"CL B&quot

HTH
Mike

 

[denko]

How stupid of me, I had the second and the third arguments switched around - InStr(4, "CL B",Table1.Field1,)
It works now
Thanks