title: Phoenix: Convert String column to Integer column
body: <p>I am looking for a Built-in UDF or any other method to convert values of a string column to integer in my phoenix table for sorting using SELECT and ORDER BY. I searched in the apache language Manual, but no use. Any other suggestions also welcome.</p>
  
  <p>Actual Query</p>
  
  <pre><code>select "values" from "test_table" 
  </code></pre>
  
  <p>I tried below approach but did not work </p>
  
  <pre><code>select TO_NUMBER("values", '\u00A4') from "test_table"
  </code></pre>