> From: "Jenda Krynicky" <[EMAIL PROTECTED]>
> Date: 2005/01/24 Mon PM 06:02:03 CST
> COUNT(<first_column>)
> doesn't count the rows in which the first_column is null.
<snippage>
> If you want the count of rows, use COUNT(*), if you want the count of
> Foos use Count(Foo).
Hard to argue with that, indeed it is. Myself, I never put a NULLable column
in the first position of a query. You know, since that is usually a KEYed
column...
Well... Usually... For me...
> Jenda
Point taken,
amonotod
--
`\|||/ amonotod@ | sun|perl|windows
(@@) charter.net | sysadmin|dba
ooO_(_)_Ooo____________________________________
_____|_____|_____|_____|_____|_____|_____|_____|
