title: Compare string values in different tables using LIKE operator in SQL Server 2008
body: <p>I have two tables. Each table has the following columns: </p>
  
  <pre><code>Address 
  City    
  ST  
  [ZIP Code]
  </code></pre>
  
  <p>I'm using SQL Server 2008. </p>
  
  <p>The string format in table the "Table_A" is different from the "Table_B"; however, the addresses may still match. </p>
  
  <p>Eg: in the "Table_A" the address is 15 W 34TH ST, but in "Table_B" address is written and plain English as follows: 15 West 34th Street.</p>
  
  <p>I need to do the best to match those addresses across the two tables from the above. </p>
  
  <p>Please </p>