Nick Upson wrote:

> Is there any time where there is an effective difference between:
>
> select count(*) from ...
>
> and
>
> select count(myfieldname) from ...
>

Yes, count(myfieldname) doesn't count the record if the value for the
selected field is null, count(*) counts all records regardless of their
value/state.

--
Magnus