Need Help : SQL problem

[Quoted] Hi to all SQL gurus out there,

[Quoted] Current facing a 'simple' SQL problem and need some help from you. I am using Oracle 8i Standard ed.

1. I have a table A.
2. I need to retrieve all records from table A which has column X being NULL.
3. Column X is a number field.

I've heard that in Oracle, NULL comparisons always end up being NULL, any other ways to do this?

Thanks.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.215 / Virus Database: 101 - Release Date: 11/16/00