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() function to convert a value or an expression from one type to another. -- CAST() function explicitly convert a value of one type to another. -- The CAST() function returns the expression ...

The cast function does not support conversions between incompatible JSON and SQL data types. For example, if you convert a JSON number to an SQL string, the function returns NULL.