Query Criteria-multiple words

[machumpion]

Suppose I am querying strings which might have multiple words/names divided by a space or other characters. i.e. Nature's Store, Nature123 Store, Natures Store

How would I write in the criteria to return anything with "Nature*" followed by a SPACE and *store*?

 

[pbaldy]

Shot in the dark, but try

Like "Nature*" And Like "* Store*"

 

[CJ_London]

or simply

Like "Nature*Store*"

or
Like "Nature* *Store*"

to ensure there is a space between Nature and Store

 

[machumpion]

works swimmingly

 

[plog]

How would I write in the criteria to return anything with "Nature*" followed by a SPACE and *store*?

Your examples, your written description and the odd SQL-like characters in your are not completely congruent. Would have been better had just stuck to english in your explanation sentence.

With that said, if you want to make sure certain substrings appear in a certain order of a main string, my advice would be to use the InStr function (https://www.techonthenet.com/oracle/functions/instr.php) that will tell you at what position each substring starts. With it you can compare to make sure your substrings appear in the correct order.