TO_FLOAT

Converts a string to a numeric REAL data type.

Syntax

TO_FLOAT(<expression>)

Parameter	Description
`<expression>`	A numeric data type or numeric characters that resolve to a `TEXT` data type.

SELECT
	TO_FLOAT('10.5');

Returns: 10.5