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 ...

Logical Functions The next grouping of new T-SQL commands is logical functions; they include two new commands, CHOOSE and IIF. These commands are used for logical operations to help control the ...