title: mysql SUBSTR() problem
body: <p>Nice easy one for this morning.</p>
  
  <p>Ok, here's my little <code>sql</code> statement</p>
  
  <p><code>SELECT SUBSTR(quote,1,20) FROM b_quotes WHERE id='74'</code></p>
  
  <p>This is returning an empty result which is confusing because if I call upon any other part of that record (the customers email address for example) it returns it perfectly. I've tried variations and it always seems to be the SUBSTR part that is failing.</p>
  
  <p>could anyone shed some light on this?</p>
  
  <p>Thanks 
  Shane</p>