title: How to specify ignore case in when statement in Sybase
body: <p>How to specify <em>ignore case</em> in a <code>where</code> statement in <a href="http://en.wikipedia.org/wiki/Adaptive_Server_Enterprise" rel="nofollow">Sybase</a>?</p>
  
  <p>Basically I want</p>
  
  <pre><code> select * from _table where _field = 'BUSY'
  </code></pre>
  
  <p>to return rows if there are any rows with values like 'BuSy' in field <code>_field</code>.</p>