i have tried looking thru documentation but have not found anything...i know that null is seen as an unknown value and you can specify null in the where clause when creating a select in sql...but does oracle recognize null as a value ? i believe it does because you can use it in the where clause but i am not sure...if anyone has any thoughts i would appreciate it...thanx