Comparison query

S

Steve

Hi,

I have a query that holds 3 addresses. Each part of the
address is seperated by a comma.

I want to be able to compare each address to find
differences between each one. Ive tried using like and
not like, but it either brings back all records or no
records!

Is there any way of doing this?

Cheers,
Steve
 
J

John Vinson

Hi,

I have a query that holds 3 addresses. Each part of the
address is seperated by a comma.

I want to be able to compare each address to find
differences between each one. Ive tried using like and
not like, but it either brings back all records or no
records!

Is there any way of doing this?

Cheers,
Steve
Click to expand...

Comparing addresses is tricky at best (is 123 Main St. the same as 123
W. Main Street?) - if you have the entire address jammed into a single
field it's doubly difficult!

Could you post a bit more detail about the nature of the table field
(or fields), and perhaps an example of what type of comparison you
want to do?

John W. Vinson[MVP]
(no longer chatting for now)
 
Top