Using # as text characters

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

Hal Pratt

I have lists of addresses, some of which have # characters to designate apt
numbers or unit numbers. When I use # symbol in queries to find these
addresses, I get all address in file since # is a wildcard char.
Is there way to express "#" in queries to find records which contain this
character?
 
Hal said:
I have lists of addresses, some of which have # characters to designate apt
numbers or unit numbers. When I use # symbol in queries to find these
addresses, I get all address in file since # is a wildcard char.
Is there way to express "#" in queries to find records which contain this
character?
Click to expand...
Hal,

Like "*" & "[#]" & "*"
 
Back
Top