title: sql-remove dashes from string column
body: <p>in stored procedure, i have this field</p>
  
  <pre><code>LTRIM(ISNULL(O.Column1, ''))
  </code></pre>
  
  <p>If there is a dash(-) symbol at end of the value, want to remove it. only in conditions if a dash symbol exist at start/end.</p>
  
  <p>Any suggestions</p>
  
  <p>EDIT:</p>
  
  <p>Microsoft SQL Server 2014 12.0.5546.0</p>
  
  <p>Expected output:</p>
  
  <pre><code>1)input: "abc-abc" //output: "abc-abc"
  
  2)input: "abc-" //output: "abc"
  
  3)input: "abc" //ouput: "abc"
  </code></pre>