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

Question

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

I.E. 'TEST STRING'

to return:

'TEST STRIN'

thanks Dave

Answer 1

e.g.

DECLARE @String VARCHAR(100)
SET @String = 'TEST STRING'

-- Chop off the end character
SET @String = LEFT(@String, LEN(@String) - 1)

SELECT @String

Answer 2

Try this:

select substring('test string', 1, (len('test string') - 1))