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

Possibly not, but be aware that count doesn't count NULL states, so the
result might differ when you are using a NULLable field.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com