db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Soumen Saha" <soumens...@gmail.com>
Subject NULL checking in Derby
Date Sat, 27 Oct 2007 02:36:19 GMT
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... My aim is to delete all the rows where the
OPTION_TEXT is empty..

Thanks & Regards,
Soumen

Mime
View raw message