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

To update the record by trimming the last N characters of a particular column:

UPDATE tablename SET columnName = LEFT(columnName , LEN(columnName )-N) where clause

Try It :

DECLARE @String NVARCHAR(100)
SET @String = '12354851'
SELECT LEFT(@String, NULLIF(LEN(@String)-1,-1))

declare @string varchar(20)= 'TEST STRING'
Select left(@string, len(@string)-1) as Tada
output:

Tada
--------------------
TEST STRIN

select left('TEST STRING', len('TEST STRING')-1)

e.g.

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

Try this

DECLARE @String VARCHAR(100)
SET @String = 'TEST STRING'
SELECT LEFT(@String, LEN(@String) - 1) AS MyTrimmedColumn

Try this,





DECLARE @name NVARCHAR(MAX) SET @name='xxxxTHAMIZHMANI****'SELECT Substring(@name, 5, (len(@name)-8)) as UserNames

And the output will be like, THAMIZHMANI

@result = substring(@result, 1, (LEN(@result)-1))

Get the last character

Right(@string, len(@String) - (len(@String) - 1))

I can suggest this -hack- ;).

select
left(txt, abs(len(txt + ',') - 2))
from
t;

[**SQL Server Fiddle Demo**](

[To see links please register here]

)