Thanks everyone, so if myfieldname is not nullable they will always be
equivalent

On 13/09/2007, Nick Upson <nick.upson@...> wrote:
> Is there any time where there is an effective difference between:
>
> select count(*) from ...
>
> and
>
> select count(myfieldname) from ...
>