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
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