title: Column update - SQL UPDATE statement
body: <p>I have a column where it stores a reference
  the reference is usually 30 alphanumeric values
  The column is set as an nvarchar (30).</p>
  <p>Id like to update this to nvarchar (5), and update all the values currently stored in this column..</p>
  <p>is there a way to do this using update?</p>