title: Pattern Matching with Like Clause
body: <p>I am attempting to use a LIKE clause in a SQL statement to match a certain pattern within Oracle.</p>
  
  <p>I would like to do something as such:</p>
  
  <pre><code>LIKE '[A-Z][A-Z][1-4]%'
  </code></pre>
  
  <p>..but <strong>I can't use a regex because this is on Oracle9i</strong> (regex support came in 10g).</p>
  
  <p>I am attempting to match something that has two characters before it, then a number between 1 and 4 and that whatever beyond that. I have attempted this, but it doesn't seem to work. The only way I have been able to get it to work is by doing:</p>
  
  <pre><code>WHERE ...
  LIKE '%1__' OR 
  LIKE '%2__' OR 
  LIKE '%3__' OR 
  LIKE '%4__'
  </code></pre>
  
  <p>I am not sure if the way I would like to do it is possible or the correct way as I have never attempted patterns with the LIKE clause.</p>
  
  <p>Any help you could give would be greatly appreciated.</p>