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