title: How do you use LEFT on a NTEXT SQL Server Column?
body: <p>How do you use the LEFT function (or an equivalent) on a SQL Server NTEXT column?</p>
  
  <p>Basically I'm building a GridView and I just want to return the first 100 or so characters from the Description column which is NTEXT. </p>