Null Query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tony (x34_at_hknet.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 21:13:34 +0800

i have a query to sort out "is not null" record.

However, i find there is null records in the result.

Then i revert the query to "null", however, there is no record.

apparently the visible "null" records are not null.

then i check through the table, the record has nothing in the field. the
field is a text field.

what's wrong? Thanks.