Search for Multiple * Literals

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.
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office 2019 for mac, will it still…? 0
Replace third space with "-" 3
Custom toolbar button for search and replace 1
Parameter Query w/ search form 3
Should I use a query for this? If so, how? 2
Query with more than 8 'OR' criteria? 2
Querying for Extended ASCII Characters 1
wildcards to search words in access 2

Top