Like most databases created in the last few decades, SQL Server ... difference. There is a workaround. Rather than using a scalar function, you may be able to use a “inline table-valued function ...