Find # sign in text string 1

[THWatson]

Using Access 2003(2000 format)

I want to be able to find records with a # sign in an Address2 field.

Entries in the field are like
RR 7
R.R. #22
RR #4

Seems as if Access treats numbers as if being the same as the # sign. Because when I put criteria in the Address2 field in a query I get, for example, all 3 rows as above.

I want to be able to find only the 2 that include the # sign.

I have tried...
Like "*#*"
Like "*" & Chr(35) & "*"

Both yield the same result.

Is there a way?

Tom

 

[PHV]

Like "*[#]*"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[THWatson]

Yep, thanks!

Tom