title: Check if a column contains text using SQL
body: <p>I have a column which is called <code>studentID</code>, but I have <em>millions</em> of records and somehow the application has input some <em>arbitrary text</em> in the column.</p>
  
  <p>How do I search:</p>
  
  <pre><code>SELECT *
    FROM STUDENTS
   WHERE STUDENTID CONTAINS TEXT
  </code></pre>