title: How to use column name as part of a LIKE statement in a WHERE clause of a JOIN
body: <pre><code>LEFT OUTER JOIN [INVENTTRANS]
  ON #TEMP.VOUCHERPHYSICAL=[INVENTTRANS].VOUCHERPHYSICAL
  WHERE [INVENTTRANS].ITEMID = #Temp.INVENTDIMID
  </code></pre>
  
  <p>This provides me nearly the result I am looking for. About 1/4th of the desired results are eliminated because <code>INVENTDIMID</code> has a suffix appended to it in certain cases.</p>
  
  <p>What is the proper syntax to succeed in a like clause similar to this intent.</p>
  
  <pre><code>WHERE '[INVENTTRANS].ITEMID%' like #Temp.INVENTDIMID
  </code></pre>
  
  <p>Alternatively, if there is no short hand way to do this, what is the most effective long handed way about it.</p>
  
  <p>Thanks</p>