Could you do in another way? My aim is to delete all the rows where the OPTION_TEXT is empty..
Soumen Saha wrote:
> DELETE FROM QUIZ_OPTIONS_INFO WHERE OPTION_TEXT IN ('',null);
> This is working in SQL Server but not in Derby... The error is Error
> code -1, SQL state 42X01: Syntax error: Encountered "NULL" . Could some
> one please tell the solution...
I'm afraid I don't know the answer.
I recommend you try asking on email@example.com. I think you
will find a lot more people on that list who know about Derby.