At 11:18 AM 10/1/2010, [email protected] wrote:

I'm officially confused.

Third test:

SELECT COUNT(STCD_NO) FROM TEMPVIEW WHERE RDY_DATE IS NULL
 COUNT (STC
 ----------
       2800


Mike,

What results are displayed when using the following command?

TALLY RDY_Date FROM TempView

What is the database SETting for EQNULL?

SHOW EQNULL will reveal the current setting for EQNULL.

Hope that provides you with some blue's clues ...

Very Best R:egards,

Razzak.


Reply via email to