Scalar FunctionsType Functions

asnumeric

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

Syntax

asnumeric(value)

Prop

Type

Returns: real

print asnumeric(dynamic(793))

print_0 (real)
793.0

aslong

Extract a 64-bit integer from a dynamic or pass through an int/long value. Other types become null.

asstring

Extract a string from a dynamic or pass through a string value. Non-string values become the empty string.