Previous Topic: -289 - <x> LITERAL <y> TOO LARGE/SMALLNext Topic: -291 - INDEX <xxxxx> NOT IN SEQUENCE


-290 - DATATYPE OF FIRST OPERAND OF LIKE NOT CHARACTER STRING

Explanation

The first operand of the LIKE predicate must be an expression with data type CHARACTER, VARCHAR or LONG VARCHAR.

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

User Response

Use an expression in the first operand of the LIKE predicate that has a character string data type.