CAST({
expr |
NULL } AS {
datatype })
CAST returns the value of
expr or
NULL as a data type. Valid data types are the same as for the CONVERT() function as well as any valid data types used in a CREATE
TABLE statement. Note that no trunctation occurs if you use the CREATE TABLE data types; any precision such as
varchar(n) is ignored.