Forwarding from the general@ list to derby-user@ to reach more Derby users.
--- Begin Message ---
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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] I think you
> will find a lot more people on that list who know about Derby.
>
> thanks,
>
> bryan
>
--- End Message ---
