Running a Query using "Like" statement

[dsegu]

Hello,



I am looking to update field A where field B meets the following criteria:

Like "*X" Or Like "*fuel" Or Like "*wards" Or Like "*gas" Or Like "*ward" Or Like "*allon" Or Like "*allons" Or Like "*wards" Or Like "*oints"

It seems to be working however I when I run the query not all occurences of the value are being captured. I am seeing over 200 occurences of just the value "*fuel" in my table however the query is only finding 18 total using all of the specified values in my criteria.

Thoughts? I am open to suggestions.

[pbaldy]

With your criteria, "fuel" would have to be at the very end of the text; is it? Try this as a test:

Like "*fuel*"

[dsegu]

With your criteria, "fuel" would have to be at the very end of the text; is it? Try this as a test:

Like "*fuel*"

It worked! Thank you so much.

[pbaldy]

Happy to help!