Search for Multiple * Literals

  • Thread starter Thread starter yator
  • Start date Start date
Y

yator

I need to use a query to search for records that contain several sequential
asterisks in addition to text. In do not want to return records that contain
other information before or after the asterisks. For example:

Should only Return: ***Resistant***

Should not Return: repeat test ***Resistant***
Should not Return: entfae ***Resistant*** see 12345

I have tried:
Like “[***]Resistant[***]â€
Like “[*][*][*]Resistant[*][*][*]â€
But they do not return any records.

I appreciate any help.
 
If you're actually looking for the literal ***Resistant***, use =
"***Resistant***". There's no reason to use Like unless you're trying to
search using a wildcard.
 
Back
Top