TO_FLOAT
Converts a string or numeric value to a double-precision floating point number (the Double datatype). TO_FLOAT ignores leading spaces.
Syntax
TO_FLOAT( value )
Argument | Required/ Optional | Description |
|---|
value | Required | Must be a string or numeric datatype. Passes the values you want to convert to double values. You can enter any valid expression. |
Return Value
Double value.
0 if the value in the column is blank or a non-numeric character.
NULL if a value passed to this function is NULL.
Example
This expression uses values from the column IN_TAX:
TO_FLOAT( IN_TAX )
IN_TAX | RETURN VALUE |
|---|
'15.6789' | 15.6789 |
'60.2' | 60.2 |
'118.348' | 118.348 |
NULL | NULL |
'A12.3Grove' | 0 |