Remove Trailing Spaces and Update in Columns in SQL Server

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))