But prior to the upcoming 2019 release, SQL Server’s support for scalar functions was fraught with problems. In SQL Server, a function that returns a single value is known as a “scalar UDF ...

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 function. See Figure 1 for a ...