Conversion Function (conversion_function) 
A conversion function (conversion_function) is a function that converts a value from one data type to another.
Syntax
<conversion_function> ::=
CHAR (
<expression>[,
<datetimeformat> ] )
| CHR ( <expression>[,
<unsigned_integer> ] )
| HEX ( <expression> )
| HEXTORAW (
<expression> )
| NUM ( <expression>
)
See also: