# in select queries

  • Thread starter Thread starter Hal Pratt
  • Start date Start date
H

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?
 
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?
Click to expand...

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

LIKE "*[#]*"

should work.
 
Back
Top