Dan,
 
When the label 'Null Item' appears in the value portion of the display,
while using the 'Report All' command in query, may actually contain data.
I have determined that the 'null item' label is always associated with
character type data (X,U,..) and all it really means is that the character
strings starts with a non ASCII character (usually a binary zero).  One
method that I've used is:
 
>Find ITEM_NAME < "      " OR ITEM_NAME > "~~~~~~"
 
Where the quoted string is equal to the length of the item.  Needless to
say that the above will perform a serial read of the dataset.
 
Regards
 
Paul H. Christidis
 
 
 
______________________________ Reply Separator _________________________________
Subject: Re: Searching for 'NULL ITEM' in query
Author:  Dan Hollis <[log in to unmask]> at CCGATE
Date:    7/2/1996 2:31 PM
 
 
> > Is there a way to search for 'NULL ITEM' fields in query?
> SELECT * FROM TABLE WHERE COLUMN IS NULL;
>
> Note the use of the word IS rather than an equal sign.  The reverse
> would be IS NOT NULL.
 
Maybe I should have made this more clear...
 
I'm wanting to search for NULL ITEM fields in Image/3000, not Image/SQL.
 
-Dan