EXTRACT_AMOUNT
Description
EXTRACT_AMOUNT
is a row function that takes a Currency value and extracts the numeric amount as a Numeric value.Syntax
EXTRACT_AMOUNT
(currency_expression
)Return Value
Returns a value of type
NUMERIC
.Input Parameters
- currency_expression
- Required. A field or expression of typeCURRENCY.
Examples
Get the numeric values from the Salary field (Currency field type):
EXTRACT_AMOUNT([Salary])