Note that the original query and the new query will produce different results if the column can contain NULLs. You need to construct your final query to handle NULLs however you prefer to handle them (count or not count).
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.