The following Microsoft SQL Server T-SQL scripts update a column to remove trailing spaces:

-- SQL eliminate traliing spaces

UPDATE TableX

SET    ColumnA = RTRIM(ColumnA)

WHERE  len(ColumnA) > 0

       AND right(ColumnA,1) = ' '

-- SQL Server eliminate trailing spaces

USE Northwind;

UPDATE Customers

SET    Address = RTRIM(Address)

WHERE  len(Address) > 0

       AND right(Address,1) = ' '

-- (0 row(s) affected)

-- Add trailing spaces for testing purposes

UPDATE Customers

SET    Address = Address + '   '

WHERE  len(Address) > 0

-- (91 row(s) affected)

-- T-SQL truncate trailing spaces

UPDATE Customers

SET    Address = RTRIM(Address)

WHERE  len(Address) > 0

       AND right(Address,1) = ' '

-- (91 row(s) affected)