Invoking a Scalar UDF From a SELECT Statement You must use the alias to reference the result of a scalar UDF invocation that has an alias.