# character in queries

H

Hal Pratt

I need to edit mailing lists which contain # characters in their address
fields (e.g., 123 Easy St #567). The problem is # is a wild character. How
can I write an expression to find records with #000 elements in them?
 

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

# in select queries 1
Removing partial character strings 3
Format text to add character 5
Query Records of Different Formats 1
sorting street names 4
replace characters in table 6
Using # as text characters 1
String Query 3

Top