Using the CLR Function Once deployed to the SQL Server, the CLR function appears in the Programmability, Functions, Scalar-valued Functions folder of the database, much like a T-SQL user-defined ...

CAST () SQL's CAST () function is similar to CONVERT (); it lacks the date formatting capabilities CONVERT () has, but otherwise works in a similar fashion.