The syntax for CAST() is CAST(variable_or_column AS datatype) This is opposed to the syntax for CONVERT(), which is CONVERT(datatype,variable_or_column) Not all data types can be converted between each other, such as converting a datetime to a text data type, and some conversions need neither a CAST() or a CONVERT().