You can specify a scalar UDF in a WHERE clause search condition if the UDF returns a value expression. See Example: Invoking an SQL UDF Within a Search Condition.
You can specify a scalar UDF in a WHERE clause search condition if the UDF returns a value expression. See Example: Invoking an SQL UDF Within a Search Condition.