Re: stupid sql question - please help

And the others have set the archive_flag to NULL?

Try
 select * from doc_prop
 where archive_flag != 'Y' or archive_flag is null;

Hth,

Sybrand Bakker, Oracle DBA

"N7SF" <n7sf_at_hotmail.com> wrote in message news:SERv5.96$jJ5.10532_at_bos-service2.ext.raytheon.com...
> I have a table that looks like this:
> SQL> desc doc_prop
> Name
> ------------------
> DOC_ID
> RESTORE_FLAG
> DATA_FLAG_NUM
> LOE_7DAY
> ARCHIVE_FLAG
> MODIFY_ID
>
> I have a few records in the table and one of the records has the
> archive_flag set to 'Y'
>
> I'm trying to select all the records that do not have the 'Y' set. Yet
> nothing I try seems to work.
>
> I have tryed:
> select * from doc_prop
> where archive_flag != 'Y'
>
> this returns nothing
> I've tryed several things all fall.. why? what is the correct way to see
 all
> the records that don't have a archive_flag set to 'Y'?
>
> Thanks for any help.
>
>
>
Received on Wed Sep 13 2000 - 15:48:30 CDT