title: Joining 2 Tables using a wildcard
body: <p>I need to Join 2 tables but there is not a true common field. In Table A the ID field contains the ID from Table B BUT it has additional characters before and after the ID.</p>
  
  <p>TableA ID
  . a J123 00</p>
  
  <p>TableB ID
  J123</p>
  
  <p>Need to Join B to A based on the J123 in Table B</p>
  
  <p>How can i write a Join statement to join table B to table A?</p>
  
  <p>Using SQL Sever 2008</p>