CAST Syntax CAST(value, type) To cast types to Number you can use one of three forms: SELECT CAST(a AS NUMBER), FORMAT(NUMBER,a), a::NUMBER See also: CONVERT, [:: - double colon](Double Colon)