title: JPQL: convert varchar to number
body: <p>How can i convert varchar to number in JPQL ???</p>
  
  <p>I managed to do that in sql (Oracle) with this query:</p>
  
  <pre><code>SELECT Decode(Upper(column_name), Lower(column_name), To_Number(column_name), -1)
  FROM table
  </code></pre>
  
  <p>I want to do this conversion with JPQL.</p>
  
  <p>Thanks for your help </p>