# in select queries

[Hal Pratt]

I want to find address records with # in the street field (i.e., 123 Easy St
#123). The problem is # is a wild character for numeric values. How can I
write an expression to find records with # characters in them?

 

[John Vinson]

I want to find address records with # in the street field (i.e., 123 Easy St
#123). The problem is # is a wild character for numeric values. How can I
write an expression to find records with # characters in them?

Putting special characters in square brackets "insulates" them and
causes them to be interpreted literally rather than as a wildcard:

LIKE "*[#]*"

should work.