query to get data from 2 criterias

[megatronixs]

Hi all,

I have a query to get data from a client's address. there are 5 fields with the address lines. In the database the town names where not all entered in the correct address fields.
this means that address_text2 and adress_text3 could have the town name. When I'm querying the database to find duplicates for the possible same client, I have no clue how to do this.
When I use the AND, it will be checking if both fields have the same and only show those that are equal, when I use OR, then I miss the ones I need.

As example I'm looking for all the persons that the forename starts with "M" and the Lastname is "Jones" the address_text2 is like "COR" and Adress_text3 also has like "COR"

How to do this so I will get all address_text2 and address_text3 that has something with "Cor" in the field?

Greetings.

[CJ_London]

something like

WHERE forename like "M*" AND Lastname = "Jones" AND (address_text2 like "*COR*" OR Adress_text3 like "*COR*")

[megatronixs]

Hi Ajax,

That really worked out nice, BIG thanks :-)

Greetings.