Conversion to number functions
We outline next all the conversion forms to numeric data type (we only specify the MS-SQL Server version of the interpretation of the functions):
Option name in the popup list |
Inserted string (where Fld is the selected field) |
Integer [99999999] |
CAST(Fld AS NUMERIC) |
Decimal [99999999.9] |
CAST(Fld AS NUMERIC(38,1)) |
Decimal [99999999.99] |
CAST(Fld AS NUMERIC(38,2)) |
Decimal [99999999.999] |
CAST(Fld AS NUMERIC(38,3)) |
Decimal [99999999.9999] |
CAST(Fld AS NUMERIC(38,4)) |
Decimal [99999999.99999] |
CAST(Fld AS NUMERIC(38,5)) |
Decimal [99999999.999999] |
CAST(Fld AS NUMERIC(38,6)) |