ParseDoubleOrDefault

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) will output: "1.1" 

Return value datatype

Double

Impact of null value

If input is null, returns null.