Is it possible to Trim all the values in a column in a single statement?

MS SQL does not have a trim function. You’ll need to use rTrim and lTrim together.

update MyTable set Name = lTrim(rTrim(name))