Previous Topic: -66 - ILLEGAL NUMBER nnnn IN ORDER SPECIFICATIONNext Topic: -69 - TOO MANY SET CLAUSES IN UPDATE COMMAND


-67 - COLUMN FUNCTIONS NOT ALLOWED IN WHERE CLAUSE OF QUERY

Reason:

The use of a column function is not allowed in the WHERE clause of a query.

The SQLSTATE that equates to this SQL return code is 42903.

Action:

The desired effect may be accomplished by specifying the column function in a HAVING clause.