Hi Brayan,

Could you do in another way? My aim is to delete all the rows where the OPTION_TEXT is empty..

Regards,
Soumen

On 10/26/07, Bryan Pendleton <bpendleton@amberpoint.com> wrote:
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...

Hi Soumen,

I'm afraid I don't know the answer.

I recommend you try asking on derby-user@db.apache.org. I think you
will find a lot more people on that list who know about Derby.

thanks,

bryan