Remove the last character in a string in T-SQL?

Question

How do I remove the last character in a string in T-SQL?

For example:

'TEST STRING'

to return:

'TEST STRIN'

Answer 1

Try the below code:

DECLARE @String VARCHAR(100)

SET @String = 'TEST STRING'

-- Chop off the end character

SET @String = 

     CASE @String WHEN null THEN null 

     ELSE (

         CASE LEN(@String) WHEN 0 THEN @String 

            ELSE LEFT(@String, LEN(@String) - 1) 

         END 

     ) END

SELECT @String