title: SQL Server TRIM character
body: <p>I have the following string: 'BOB*', how do I trim the * so it shows up as 'BOB'</p>
  
  <p>I tried the RTRIM('BOB*','*') but does not work as says needs only 1 parameter.</p>