I am trying to compare a column of type LONG VARCHAR using the = operator with a string constant.

I am getting an error the the operants aren't compatible for the = operation.
I have tried to cast the constant to LONG VARCHAR but it had no success.

Do I have to use a special way to compare LONG VARCHAR?

Thank you
Gaganis Georgios