SQL Server Functions
T-SQL supports many built-in functions.
Scalar function returns a single value.
Table-valued function returns a table result.
Conversion functions
SQL supports number of functions that can convert a source expression to a target data type.
SQL Server conversion functions are CAST and CONVERT.
CAST:
It converts an expression from one