Return-Path: 
 <derby-user-return-7950-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 16986 invoked from network); 30 Oct 2007 19:21:36 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 30 Oct 2007 19:21:36 -0000
Received: (qmail 1238 invoked by uid 500); 30 Oct 2007 19:21:22 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 1218 invoked by uid 500); 30 Oct 2007 19:21:22 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Delivered-To: moderator for derby-user@db.apache.org
Received: (qmail 50419 invoked by uid 99); 27 Oct 2007 02:36:36 -0000
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of soumensaha@gmail.com
 designates 209.85.198.184 as permitted sender)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=beta;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        bh=LhmALfVOQ0ygpdpq56Kwz5Pa6qL8l2yhG9oVLYSZf3s=;
        b=lC9qQalNaF3Rz5wpr9L5zGADDKPUE3HH6Y71IJ1EUND3WxPNIxxdU+r0nqIj6VX7JBFF/QKEnrURBdQ8BxtldejGElf1aqmA5+8trzVVvIB6xnaBAg51ZwezEO/4k5GzS1MTK3EYoDBXDo+xltzBuntMg4nRaCyLPgHiI0pgV6M=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=VMRuAqolbzrF3UFGgnndf5dI6oz8PUMMKvVTIRP4n/i6mR9x+NDqFK0Eq2an3xXP+2gIkXQl/bLp63522uH95jg+TI7oKQBHT5qK8WXIRzrBp/NZgivesY0EYx2R8R8kGKxAuRs9ZlgundTPqgXevT9nOdFGoKCpR+cpojlk2Wo=
Message-ID: <1eb85fd50710261936i6876c447u2989e614d4330e88@mail.gmail.com>
Date: Fri, 26 Oct 2007 22:36:19 -0400
From: "Soumen Saha" <soumensaha@gmail.com>
To: derby-user@db.apache.org
Subject: NULL checking in Derby
In-Reply-To: <1eb85fd50710261743m78eb4f0fl576aeeeb0c44ec4f@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_5599_28736403.1193452579447"
References: <1eb85fd50710261743m78eb4f0fl576aeeeb0c44ec4f@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_5599_28736403.1193452579447
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_5599_28736403.1193452579447
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<span class="gmail_quote"><br></span>DELETE FROM QUIZ_OPTIONS_INFO WHERE OPTION_TEXT IN (&#39;&#39;,null);<br><br>This is working in SQL Server but not in Derby... The error is<span style="color: rgb(204, 0, 0);"> <span style="color: rgb(153, 0, 0);">
Error code -1, SQL state 42X01: Syntax error: Encountered &quot;NULL&quot; 
</span></span><span style="color: rgb(153, 0, 0);">.</span> Could some one please tell the solution... My aim is to delete all the rows where the OPTION_TEXT is empty..<br><br>Thanks &amp; Regards,<br><span class="sg">Soumen
<br>
</span><br>

------=_Part_5599_28736403.1193452579447--