🚀 go-pugleaf

For most DBMS:

SELECT * FROM Normal WHERE Report_Date IS NULL

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"chao" <lylyx@ynmail.com> �������/�������� � �������� ���������:
news:3e56cf0e@newsgroups.borland.com...
> 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.
>
>