SQL Server TRIM character

Question

I have the following string: 'BOB*', how do I trim the * so it shows up as 'BOB'

I tried the RTRIM('BOB*','*') but does not work as says needs only 1 parameter.

Answer 1

LEFT('BOB*', LEN('BOB*')-1)

should do it.