I have two tables from two different sources that houses location information. I need to produce a bunch of queries that will match up the two and place the matched info into a third table. The problem is the identifiers are totally different. The spelling is totally different. Eg (Saint, St.) (Street, St.) (Rd, Road) You get the idea. Somethings are in proper case, somethings are not. Can anyone give me a few generic queries that can match up this mess. I know I'll never get %100, but close is good enough.