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.

