Using # as text characters

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

fredg

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 "*" & "[#]" & "*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria for an email address fied 2
How do I use an update query to replace "Apt" with "#" ? 4
Searching for non-alphanumeric characters 2
Query design view - commas being changed to pipe characters 4
retrieve last three characters of field 2
Tricky Wildcard 2
Pipe character in query in VB6 app 11
Query for # character not working 2

Top