Dan,
    I'm not sure on the Query Syntax, but if you had installed </ Plug> an
Omnidex Multiple key on this field, you could find all records where this
fields is blank using the argument "@ AND NOT 0:z@;"   The "@" would qualify
every record (whether it has a value for this key or not) and the "AND NOT
0:z@" will subtract out every record for which we do have a value; leaving a
subset of records which don't have any value for this key.
 
  Side note: Currently; QUERY only knows about Omnidex composite keys; not
about keys on actual fields...
</end Plug>
 
 
Rich
______________________________________________________________________
________ Dynamic Information Systems Corp.   |
\!DISC / Rich Trapp                          | My opinions are my own.
 \    /  OMNIDEX Product Manager - IMAGE/SQL | With any luck they're
  \  /   Phone : 303 444-4000                | correct ;-)
   \/    E-mail: [log in to unmask]                |
 ----------------------------------------------------------------------
 
>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
>