Finding a string by itself

[enthrop]

Hey,

I know this should be simple, but I can't think of what expressions to you use.

I want to find any fields with the string "IS" in them.

I've been using: Like "*IS*"

BUt it picks anything with IS up: (ie RISK, FRISK, MISS)

How can I limit it to ONLY IS

(IS the sky grey?)
(How cold IS it?)
(... IS)

I tried scanning for _IS and IS_, but then It doesn't detect just IS (which I also need it to do).

Tips? thanks

 

[SonOfEmidec1100]

Tricky it will depend on the possible separators, however if IS always has a space before or after, or is the only word then

WHERE Field Like "* IS*" OR Field Like "*IS *" OR Field = "IS"


Maybe this helps ?

 

[cottontop]

Sun is right, but if you're looking for the word "is" only and it's preceeded and followed by a space, you have to include "* is *".

If you're only looking for "is", you will have to have three statements:

"is *" : where "is" begins the text and has a space following.
"* is *" : where "is" is somewhere in the text preceeded and followed by a space
"* is" : where "is" is the last word of the text but is preceeded by a space

 

[cottontop]

Look here: Thread701-581840

 

[scriverb]

Thanks Cottontop. I was just about to direct him to that thread.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???