[RBG7-L] - Re: Null character

[A. Razzak Memon]

At 04:44 PM 8/6/2004 -0400, Joel Solomon wrote:

I have data that looks like a null (-0-) but does not act like a null.

Joel,

The BEST way to identify NULL values is to use TALLY
command to differentiate between the actual vs. NULL
values.

The NULL data with the correct count will be at the
end of the list.

You can also use the following technique to find the
actual count of rows having that particular column as
NULL.

SET VAR vRows INTEGER = 0
SELECT COUNT(*) INTO vRows INDIC ivRows +
FROM tablename WHERE colname IS NULL

That should also give the correct count.

Very Best R:egards,

Razzak.