Scalar FunctionsType Functions

to_numeric

Extract numeric value from dynamic or pass through numeric types. Non-numeric values become null.

Syntax

to_numeric(value)

Prop

Type

Returns: real

print to_numeric(dynamic(793))

print_0 (real)
793.0

new_guid

Returns a random GUID string.

tobool

Convert the input to a boolean.