How can I use ‘ALL’ in a CONTAINS expression?
I have a customer “All Phase” and want to find all instances of it in the Name, Address1 and Address2 fields on the Customer table.
“ALL” seems to be a key word and it does not filter on it and brings back all results with “Phase” in the name.
Try
Like ‘%ALL%PHASE%’ on the three fields
or LIKE ‘%ALL[ ]PHASE%’
Thanks
The %All%Phase% got me closest. Only one record where someone put an email address with a portion of the criteria to remove. (all-phasect)
Welcome 
Trying to do criteria with a field that CONTAINS FM on the Parts table. The ‘%FM%’ doesn’t work.
What @Mark_Wonsil said if a BAQ LIKE ‘%FM%’ should do the trick.
For dashboard contains you need to use * for wildcards.
If you have an issue with similar item feel free to begin a post with your issue 