title: Concatenation in SQL select query on Excel sheet
body: <p>I have upload an Excel file now I want to read data from that sheet with a <code>select</code> query, and I want to concatenate 4 columns with separator <code>_</code> as Type_name</p>
  
  <p>The query I  used is </p>
  
  <pre><code>select 
     *, '1' as fileid, 'Size' + '_' + 'Material' +'_' &amp; 'Finishing' + '_' + 'Sides' as Type_Name  
  from [sheet1$] 
  where [Current Code] is not null or [Current Code] &lt;&gt; ''
  </code></pre>
  
  <p>All data is correctly returned by query except <code>Type_Name</code>  </p>
  
  <p>This query return <code>Type_Name</code> as <code>Size_Material_Finishing_Sides</code></p>