Double Coercion

DOUBLE(<Expression>) - Coerces value of expression to type double

DOUBLE(4)

Evaluates to 4.0

DOUBLE(4.5)

Evaluates to 4.5

DOUBLE("A String")

Evaluates to 0.0

DOUBLE("3.5")

Evaluates to 3.5

DOUBLE("3.5 inches")

Evaluates to 3.5

DOUBLE("The circle measures 3.5 inches in diameter ")

Evaluates to 0.0

DOUBLE(MPOINT(0,0,1))

Evaluates to 1.0

DOUBLE(MPOINT(3,4,5))

Evaluates to 7.0711