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

Yes, count(field) skips nulls, count(*) is "true" row count, nulls or not.

Sasha