In SQL Server, a function that returns a single value is known as a “scalar UDF” or “scalar user defined function ... you may be able to use a “inline table-valued function” or ...