How to query empty field

Article View: borland.public.cppbuilder.database.ado

Article #2875

Back to borland.public.cppbuilder.database.ado Previous Next

#2875

From: chao
Date: Sat, 22 Feb 2003 01:14

19 lines
1704 bytes

Hi all, Does anyone can tell me how to query records that some fields has no
content.
for example:
Table Name: Normal
---------------------------------------
ID    Report_Date    Reporter    ...
1     2002-05-05     aaa
2                    fdf
3     2003-1-15      bbb
4     2003-2-1       ccc
5                    ddd
6                    ddd
-----------------------------------------
the exaple is my database structure
I want query all the record that Report_Date field is NULL,
i.e. the second the fifth and the sixth record will be found.
I think the SQL will be like this:
select * form Normal where Report_Date = NULL
but I can not find any record.

Technical Details

Message-ID: <3e56cf0e@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,61cd8900d120307,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-02-21 17:31:49 PST
Reply-To: "chao" <lylyx@ynmail.com>
From: "chao" <lylyx@ynmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to query empty field
Date: Sat, 22 Feb 2003 09:14:53 +0800
Lines: 21
Organization: CK
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 210.14.178.249
Message-ID: <3e56cf0e@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1045876494 210.14.178.249 (21 Feb 2003 17:14:54 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail