title: update rows where length > 50
body: <p>I have a table lets call it 'People' and it has a column called 'Name' lets say it used to have column specification of Varchar(500) and now it will be changed to Varchar(100)</p>
  
  <p>What TSQL can I write to do this update and basically trim each row where a row contains a name > 100 chars</p>
  
  <p>Ive got this so far to identify the rows, I know how to update rows, so do I need a cursor or is there some other efficient way? (Only about 100 rows)</p>
  
  <pre><code>SELECT Id, LEFT (Name, 100) FROM People
  </code></pre>