title: Remove last character from string column in SQL
body: <p>I have these special characters " ||~|| " at the end of each value in column X. I need to remove these special characters.</p>
  
  <p>Right now I am using this syntax, but it doesn't seem to accomplish the task for all rows.</p>
  
  <pre><code>set [Customer Num] = substring(ltrim(rtrim([Customer Num])),3,len([Customer Num]))
  </code></pre>