Pollard, Mike wrote:
>>Firstly, if you just want a count, what's wrong with count(1) or
>>count(*).
>>
>
>
> Because unless the column does not allow nulls, they will not return the
> same value.
Ah, but in the example given the column was being matched against a
value, so nulls were already excluded.
-- Richard Huxton Archonet Ltd