Have you tried this update tableA set fieldname = rtrim(fieldname) if fieldname was a char(10) and the record had a value of 'abc' then this should...
Can someone explain the difference between a clustered index seek and a clustered index can? Which is faster, why is one chose over the other etc....
Separate names with a comma.
