A variation on your suggestion worked !!!   I used: "description is null",
with a space between "is" and "null".

Thanks for your help.

> ----------
> From:         Steve Harrison[SMTP:sharris1 AT ISMA DOT COM]
> Sent:         Monday, October 05, 1998 12:20 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: SELECT of archive files with null descriptions
>
> Robert Wrote:
>
>
>
> To you SELECT gurus out there...
>
> The following SELECT statement works fine for me to list all archives done
> from a client:
>
> SELECT hl_name,ll_name,description from archives where node_name='SCCAT"
> and
> type='FILE'
>
> When I try to list only those files with a certain description, the
> following works great:
>
> SELECT hl_name,ll_name,description from archives where node_name='SCCAT"
> and
> type='FILE' and description='MY ARCHIVES'
>
> Now, I am stumped on how to list those archives with a null description
> (from when this client was at Version 2).  I have tried:
>
> SELECT hl_name,ll_name,description from archives where node_name='SCCAT"
> and
> type='FILE' and description=''
>
> SELECT hl_name,ll_name,description from archives where node_name='SCCAT"
> and
> type='FILE' and description=' '
>
> Any suggestions???
>
> I believe U have to check for description=isnull or maybe
> description=null.
> I had the same problem trying to check for blank version numbers awhile
> back.  If this does not work, I will check at home for the answer ... I
> emailed my home so I would always have the answer no matter where I was
> working ... ; )
>