title: Having trouble with case in sql
body: <p>Im trying to get all the numbers in my table, starting with a certain number. But sometimes my system save numbers wrong, and puts 1234 in front of the real number.
  So if the number looks like this: 65451, sometimes the systems makes it look like this: 123465451</p>
  
  <p>Im trying to remove the first 4 chars and then just use the leftovers.</p>
  
  <pre><code>Select *
  from Table_name
  
             WHERE Number = (CASE
                             WHEN SUBSTR (Number, 0, 4) = '1234' THEN SUBSTR (Number, 5)
                             ELSE
                                TO_CHAR (Number)
                          END)
  </code></pre>