db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: [Fwd: Re: NULL checking in Derby]
Date Sat, 27 Oct 2007 14:43:47 GMT
> 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


Mime
View raw message