Unfortunately, SQL Server never fully integrated scalar UDF support into its execution ... how expensive a scalar function is. All scalar functions, no matter how simple or complex, are given ...