If I've got a database record where the column 'type_cd' column is NULL, would that record be returned in a webfocus query where clause like:

WHERE TYPE_CD EQ ''

???

If not, how do you query on NULL column values?

Nevermind. I figured it out. I have to use:

WHERE TYPE_CD EQ '%NULL%'

say Chris, tell us what kind of database you're reading, would you?

use SET ALL=PASS
and then use a selection test that no other records will pass.
with ALL=PASS, null or missing values are considered to pass any selection tests.

adelaide,
i do believe all=pass is a bit different, for a JOIN where no screening condition is applied that would affect a field in the guest file, hence the pass; a different interpretation from suggesting that screening conditions of any kind would be obviated by it use.
-s.

Try:
WHERE TYPE_CD IS MISSING