title: Trim on a table column in SQL Server 2005
body: <p>I have a table called <code>Examination</code> and a column <code>Name</code>. In this <code>Name</code> column lot of values are with leading spaces and trailing spaces. I want to know how to update this column so that there are no spaces in the values.</p>