DECLARE @str VARCHAR(50)='Computer'
SELECT SUBSTRING(@str, 1, LEN(@str)-1) AS Result
Remove Last Character from String in SQL
Using this code, we can remove last char from string in SQL.
Loading
Using this code, we can remove last char from string in SQL.
DECLARE @str VARCHAR(50)='Computer'
SELECT SUBSTRING(@str, 1, LEN(@str)-1) AS Result