title: concat two columns in sql
body: <p>I have four columns on data gridview and want them to concat  in sql and exporting it to txt file but everytime i export this is my result. </p>
  
  <p>My result </p>
  
  <pre><code>0010000 01500 00000 0001600 
  </code></pre>
  
  <p>output required</p>
  
  <pre><code>001000001500000000001600 
  </code></pre>
  
  <p>SQL Query:</p>
  
  <pre><code> string stringSql = " SELECT distinct  " +
       "REPLACE(RIGHT('00'+CAST(CAST(bat.PCN_Charge* 100.00 AS INT) AS VARCHAR(5)),8) as CLAIMAMT, + RIGHT('0'+CAST(CAST([CFee] * 100 AS INT) AS VARCHAR(5)),5),' ','' )as CFEE," +
        "REPLACE(RIGHT('00000'+CAST(CAST([Solictors Fees]  AS INT) AS VARCHAR(5)),5), + RIGHT('000'+CAST(CAST(bat.PCN_Charge + [CFee]*100 AS INT) AS VARCHAR(5)),9),' ','') as TotalAMT " +
  </code></pre>