CAST

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.