Full And Partial Matching

A

Ahliank

Hi All,

I have a query that I am trying to use to return names and addresses that
match partial(match half or more character)or full to another field. And
maybe i need function to remove the special character from the field (eg:
Comma)

Thanks in advance for your help
 
K

KARL DEWEY

You can remove spaces, commas, dashes like this --
Clean_Field: Replace(Replace(Replace([YourField], " ", ""), ",",""), "-","")
 

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

Partial match Join query 3
Partial Match query design 3
Partial information queries 2
Identifying partial string matches 2
With F1 value, look at A, if match or partial match return B 5
Partial Parameters 4
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
Queries with partial matches between tables 4

Top