Yeah, NULL is a special case. Nothing is equal to it, not even NULL. By that same token, I doubt that anything is greater than or less than NULL. Give this article a read: http://thinkoracle.blogspot.com/2005/05/null-vs-nothing.html Also be sure to read the first comment from HJR. Don. On 8/2/07, Thomas Day <tomdaytwo@xxxxxxxxx> wrote: > This works perfectly fine for me in 10.2 > > select OWNER, TABLE_NAME from dba_TABLES where owner >= CHR(0) > AND TABLE_NAME >= CHR(0) > ORDER BY 1,2 > > On the other hand "null" is undefined. It's not CHR(0). > > > > On 8/2/07, Wojciech Skrzynecki <wojciech.skrzynecki@xxxxxxxxx> wrote: > > Hello > > > > What component in DB I have to install to use ">= CHR(0)" instead of > > "is not null" . > > > > > > > > -- > > Wojciech Skrzynecki > > Database Administrator > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > > > -- Don Seiler oracle: http://ora.seiler.us ultimate: http://www.mufc.us -- //www.freelists.org/webpage/oracle-l