CAST

Causes the system to treat the specified expression as the designated data type.

For example, CAST(P("CreditLimit") AS STRING) would cause the system to treat the value of the property "CreditLimit" as a string, rather than as a number.

Return Value

Can vary

Syntax

CAST( expr AS DATATYPE )

where:

  • expr is an expression of any data type.
  • DATATYPE is one of the following types:
    • DATE
    • NUMBER
    • STRING