Convert Text field into Integer Type in ROQL

Summary

Type casting Text field column into Integer type using ROQL Query

Content

Hi,

We have business requirement to convert Text data type field value into Integer type value using ROQL. For example 

Field Name        Data Type          Value              Need to Convert

field_a                   Text                 $65.00              65

I need to convert $65.00 value (field_a) using ROQL. I know CAST() in SQL but it did not work in ROQL.

Select ID, CAST(field_a AS Int) From Custom Object

Anyone has an idea how to convert text data type to Integer using ROQL

Thanks!!

Baljeet

 

Version

Oracle Service Cloud 20 C