title: Using LEFT on a TEXT-field in SQL Server
body: <p>In a table, I have a text-field. I need to be able to select only the first 200 chars of the field - but LEFT does not work with TEXT-fields.</p>
  
  <p>What to do?</p>