title: SQL concatenation inside VBA string
body: <p>I'm using VBA excel 2003,SQL 2005 to make a sql query call and inside my sql statement I'm using '+' operator to concatenate two strings.</p>
  
  <pre><code>dim query as string
  query =  "Select distinct ', '+emailaddress1 "
  query = query &amp; "from contact "
  </code></pre>
  
  <p>would this work inside vba? My query returns too many records in excel but not in SQL?</p>
  
  <p><strong>Please just focus on this 2 lines of code and not worry about the rest of my sql call, I'm just wondering whether or not this specific string would work?</strong></p>