stupid sql question - please help

From: N7SF <n7sf_at_hotmail.com>
Date: Wed, 13 Sep 2000 13:41:19 -0700
Message-ID: <SERv5.96$jJ5.10532@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:41:19 CDT