The following functions support data type casting and converting.
CAST and CONVERT (Transact-SQL)
PARSE (Transact-SQL)
TRY_CAST (Transact-SQL)
TRY_CONVERT (Transact-SQL)
TRY_PARSE (Transact-SQL)