searching for special characters, such as /

[efandango]

I have a list where some words are divided by the forward slash '/'. How can
I search for any records that contain the / character?. I have looked in
help, but cannot find any reference to this character.

 

[raskew via AccessMonster.com]

x = "abc/def"
? instr(x, "/")
4

So, in your query:
WHERE Instr([myfield], "/")>0

Bob

 

[Bob Barrows [MVP]]

I have a list where some words are divided by the forward slash '/'.
How can I search for any records that contain the / character?. I
have looked in help, but cannot find any reference to this character.

Or:
WHERE myfield LIKE '*/*'

 

[efandango]

Thanks Bob,

that worked a treat...

Or:
WHERE myfield LIKE '*/*'
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"