Microsoft SQL Server 2000 Best Practices
The following script updates a column where the cell has trailing spaces:
update TableX set ColumnA = RTRIM(ColumnA) where len(ColumnA) > 0 and right(ColumnA,1) = ' '
