We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Convert Text field into Integer Type in ROQL

Question
21
Views
0
Comments
edited Dec 17, 2020 11:28PM in Integrations and APIs

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
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!