Using # as text characters

[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?

 

[fredg]

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,

Like "*" & "[#]" & "*"