Null values in a Query

[vijip2001]

All,

I am using vb6 that executes query against RDB.
How do i check for null values in a query?

I oracle i use "select nvl(column,0) from dual;"

Can someone help me?

Thanks,
Viji

 

[genomon]

This is a VBA forum; you will have better luck in the VB5/6 forum here: forum222
That being said, post the SQL you are using there along with your question. Generally you would use A WHERE clause, such as WHERE whatever IS NULL.

An làmb a bheir, ‘s i a gheibh.