title: Compare Strings in Oracle
body: <p>I need to query a table for values given a string. The table is case sensitive but I want to do a ToLower() in the comparison. </p>
  
  <p>Suppose I have a classes table with the following data.</p>
  
  <pre><code>class    teacher
  -----------------
  Mat101   Smith
  MAT101   Jones
  mat101   Abram
  ENG102   Smith
  </code></pre>
  
  <p>My query should be something like</p>
  
  <pre><code>Select teacher From classes where lower(class) = 'math101'
  </code></pre>
  
  <p>Is this the best way to do the comparison?</p>
  
  <h2>Update</h2>
  
  <p>I have no control over the database or the data. I am a read only consumer.</p>