Table query question - wildcards


#1

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?


#2

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


#3

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


#4

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


closed #5