Yes, but you should probably use count(*) because that's what you mean.
Using count(<fieldname>) requires you (someone else reading your code)
to examine the nullability of <fieldname> to be able to determine if it
will result in the same thing as count(*) or not.

This is usually more important than you think - readability.

Kjell

Nick Upson wrote:

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

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64