title: Silly TSQL Question - Taking (N) Characters in Select Statement
body: <p>I have a select statement where I want to take 100 characters from a field. Is there an easy way to do this?</p>
  
  <p>Here is some pseudo code below.</p>
  
  <pre><code>Select substring(0, 100, longField)
  from myTable
  </code></pre>