Search for partial field

[j_a_monk]

I am trying to create a query to search for all records containing a specific string as a portion of 1 field.



How would I get all entries containing "Tick" when some fields will have "The Tick..." or "Tick...", etc.

I have tried all the operators I can think of and have not conjured the correct Google-fu to figure it out. I tried searching on here, but the same googly limitations hampered me.

Thank you in advance,
JF

[Rixxe]

If you just want to find "Tick" then i'm sure:

WHERE Field1 = 'Tick'

If you want to find all the fields which contain something to do with "Tick" then:

WHERE Field1 like '*Tick*'

Good Luck

[j_a_monk]

Thank you, that worked

[Rixxe]

You're welcome