title: SQL LIKE operator not showing any result
body: <p>I am trying to return all of the project numbers that start with a particular year code (e.g. '19').  Project numbers are formatted in '19-0100' format always.  However, the code runs but returns no results</p>
  
  <p>I've looked at some similar posts and tried the solutions suggested; still doesn't return any results.  Data in the projectnumber column is formatted as short text with no extra spaces before or after numbers as one other post suggested.  </p>
  
  <pre><code>SELECT ProjectNumber, client, ProjectTitle 
  FROM ProjectNumbers 
  WHERE ProjectNumber LIKE '19%'
  </code></pre>
  
  <p>This should give me a list of all the project numbers that start with 19 (e.g. it should return <strong>19</strong>-0100, <strong>19</strong>-0101... but not <strong>18</strong>-0100), but  get nothing at all.</p>
  
  <p>I've also tried '19-%', '19-____', '19-%', and '19_____'. All have the same result.</p>
  
  <p>Any help is appreciated.</p>