Example: Using an SQL UDF in a DELETE Request WHERE Condition - Analytics Database - Teradata Vantage

You can specify an SQL UDF in a WHERE clause search condition if it returns a value expression.

     DELETE FROM t1
     WHERE a1 = test.value_expression(b1, c1);