How do I remove the last character in a string in T-SQL?
For example:
'TEST STRING'
to return:
'TEST STRIN'
Try the below code:
DECLARE @String VARCHAR(100)SET @String = 'TEST STRING'-- Chop off the end characterSET @String = CASE @String WHEN null THEN null ELSE ( CASE LEN(@String) WHEN 0 THEN @String ELSE LEFT(@String, LEN(@String) - 1) END ) ENDSELECT @String
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