是否可以在单个语句中修剪列中的所有值？

I've a table in a (MS) SQL database which has an Id column (identity, int) and a Name column (varchar(250)). However, the values in the name column contain (fairly random) leading and trailing spaces as I think they were cut and pasted from "something else" (no idea what!).I've a table in a (MS) SQL database which has a