Thank u for the replies. The Is null property does work, but works only in the connection object but not the recordset object. But this problem is usual in case of the Db2 database.

Ajay