EXTRACT_CODE_TEXT
Description
EXTRACT_CODE_TEXT
is a row function that takes a Currency value and extracts the currency code as a Text value.Syntax
EXTRACT_CODE_TEXT
(currency_expression
)Return Value
Returns a value of type
TEXT
.Input Parameters
- currency_expression
- Required. A field or expression of typeCURRENCY.
Examples
Get the currency code information from the Salary field (Currency field type) as a Text field:
EXTRACT_CODE_TEXT([Salary])