Table query question - wildcards

Does table.query provide for wildcards in text fields like [name] like “PALM%”? Is the only option to create a separate list of values for each shape to search?

Table.Query uses an Expression which can hold wildcards.
If you download MW5 you can visually test it.
I just tried and this Expression works:
[CITY_NAME] LIKE "Ab%"

Hi @jonwinchester, did my answer help you?
If so I will close this question.

This worked perfectly. My search is working now. Thanks.