How to change the data type of a value fetched in DataQuery
Problem: Customer wants to SET and Declare a variable in the DataQuery or change the datatype of an existing field retrieved from the DataQuery
Solution: SET and Declare function is not supported in the DataQuery, but the CAST function is supported.
For example, "Select cast( Id as varchar) from Invoice"
The above query will convert the value of the field “Id” into varchar datatype.