SQL Server Type Conversion Functions This page lists the commonly used data type conversion functions in SQL Server. CAST The CAST() function is a type conversion function in SQL Server that converts a value of one data type to another. CONVERT The SQL Server CONVERT() function is used to convert a value of one data type to another data type.