title: Compare "Firstname Lastname" with "F. Lastname" in SQL
body: <p>I have two tables, <code>Table1</code> and <code>Table2</code>.</p>
  
  <p><code>Table1</code> consists of a column (<code>FullName</code>) of names in the format <code>'FirstName LastName'</code> and a unique identifier (<code>Key</code>). <code>Table2</code> has a column (<code>Name</code>) consisting of these names but in the form <code>'F. LastName'</code>.</p>
  
  <p>I would like to replace the Names in <code>Table2</code> with the unique identifier (<code>Key</code>) from <code>Table1</code>. This requires a comparison of the strings in <code>FullName</code> and <code>Name</code> (this comparison is bijective).</p>
  
  <p>Is this possible to do using SQL? </p>