Remove Trailing Spaces and Update in Columns in SQL Server
Solution 1:
Try
SELECT LTRIM(RTRIM('Amit Tech Corp '))
LTRIM - removes any leading spaces from left side of string
RTRIM - removes any spaces from right
Ex:
update table set CompanyName = LTRIM(RTRIM(CompanyName))
Solution 2:
To just trim trailing spaces you should use
UPDATE
TableName
SET
ColumnName = RTRIM(ColumnName)
However, if you want to trim all leading and trailing spaces then use this
UPDATE
TableName
SET
ColumnName = LTRIM(RTRIM(ColumnName))