Phoenix: Convert String column to Integer column

[Chinna ts]

Hi,

I am looking for a Built-in UDF or any other method to convert values of a
string column to integer in my phoenix query for sorting using SELECT and
ORDER BY.

I searched in the apache language Manual, but no use. Any other suggestions
also welcome.

Actual Query

select "values" from "test_table"

I tried below approach but did not work

select TO_NUMBER("values", '\u00A4') from "test_table"