title: Concatenation with Null in SQL Server
body: <p>I have a simple code below.</p>
  
  <pre><code>Select columnA, columnB, columnC
    From table.
  </code></pre>
  
  <p>Here is my result.</p>
  
  <pre>
  ColumnA  ColumnB  ColumnC
  Apple    G        null
  Juice    S        T9
  </pre>
  
  <p>Now, I use the concatenation as follow</p>
  
  <pre><code>Select 
    ColumnA + '_'+ ColumnB + '_' + ISNULL(ColumnC, '') as Name
    From table
  </code></pre>
  
  <p>My output is as below </p>
  
  <pre>
  Name
  Apple_G_
  Juice_S_T9
  </pre>
  
  <p>How do I modify the concatenation above so it would show as Apple_G instead of Apple_G_
  Basically, I have an extra _ from my result.</p>