title: How to remove last character of the string using tSQL?
body: <p>All i need is to remove last character which is comma (,) in this case. </p>
  
  <p>I tried <code>Substring, Left, and Right</code> functions but they need <strong>length of the string</strong>. </p>
  
  <p>Here is the scenario:-</p>
  
  <pre><code>select 
  (Case col1 &amp; 1 When 1 Then 'Case 1,' Else '' End)  + 
  (Case Col2 &amp; 2 When 2 Then 'Case 2,' Else '' End)  +
  (Case Col3 &amp; 4 When 4 Then 'Case 4,' Else '' End)  
  as Case
  from table_01
  </code></pre>