You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Bryan Pendleton <bp...@amberpoint.com> on 2007/10/27 16:31:39 UTC

[Fwd: Re: NULL checking in Derby]

Forwarding from the general@ list to derby-user@ to reach more Derby users.

Re: [Fwd: Re: NULL checking in Derby]

Posted by Bryan Pendleton <bp...@amberpoint.com>.

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

>      > DELETE FROM QUIZ_OPTIONS_INFO WHERE OPTION_TEXT IN ('',null);

Perhaps:

   delete from quiz_options_info where option_text = '' or option_text is null;

thanks,

bryan