Description
Attempts to convert a string representation of a number to a double-precision numeric equivalent. If successful, returns the string as a double-precision numeric value, otherwise returns the default value.
Syntax
ParseDoubleOrDefault(string_expression, default_value)
Arguments
string_expression - string
default_value - double
Examples
ParseDoubleOrDefault(string1,1.1) using string1 as input
ParseDoubleOrDefault('635.1',1.1) will output: "635.1"
ParseDoubleOrDefault('Testing',1.1)
Return value datatype
Double
Impact of null value
If input is null, returns null.