In SQL Server, a function that returns a single value is known as a “scalar UDF” or “scalar user defined function ... you should see no difference between a query with pasted-in logic ...

An array of parameters is typically presented as a menu before a user enters a query. User-defined functions in SQL Server fall into three categories: scalar functions that return a single value, ...