Hi

I'm trying to to make a query where to compare the address listing,
i've done the compare in Excel with the first 5 characters, works fine, but I want to do it in sql to.

Example.

table 1:
PhoneNumber, Address

table 2:
PhoneNumber, Address, StreetNumber

select table1.phonenum ber, table1.address, table2.phonenum ber,address,str eetnumber

...