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 ... ; )