The spellnumber function spells the integer portion of a numeric value.
Syntax
Returns
A text value
Usage
spellnumber(999999999) returns Nine Hundred Ninety Nine Million, Nine Hundred Ninety Nine Thousand, Nine Hundred Ninety Nine.
Examples
Returns: Three
Returns: Three Hundred Twenty Three
spellnumber ( RESERVATION ID )
Returns: The spelled-out number in the RESERVATIONID field for every record that is processed. If a record contains the value 10251, in the RESERVATION ID field, the function returns Ten Thousand Two Hundred Fifty One.