title: Concatenate in classic asp/vbscript SQL string
body: <p>I'd like to select columns and join tables where the join condition concatenates the selected columns in additions to dots. For e.g.</p>
  
  <pre><code>SELECT TBL1.ID,
  TBL1.COUNTRY As A,
  TBL1.STATE As B,
  TBL1.CODE As C
  FROM TBL1, TBL2
  WHERE TBL2.ID = A+'.'+B+'.'+C
  </code></pre>
  
  <p>The data is so that <code>TBL2.ID</code> looks like '<strong>US.NY.61</strong>' where <strong>US</strong> is <code>TBL1.COUNTRY</code>, <strong>NY</strong> is <code>TBL1.STATE</code>, etc.</p>
  
  <p>UPDATE: SQl fiddle: <a href="http://sqlfiddle.com/#!3/26b6b/4" rel="nofollow">http://sqlfiddle.com/#!3/26b6b/4</a></p>