CAST expression is used to convert one data type to another. It is similar to the various field-type functions (e.g. CHAR, SMALLINT) except that it can also handle null values and host-variable parameter markers. CAST syntax: CAST( <Expression> AS Type [ (Length) ] )      <NULL>     <Parameter Maker> CAST Rules: EXPRESSION: Value […]