Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by James Travis I want to dispaly 0 when the resultset of count(*) is zero RE: I want to dispaly 0 when the resultset of count(*) is zero

  • December 3, 2009 at 11:14 am

    #1087272

    I found the solution.

    the secret was to use the Group By All clause, then one would see the zeros for the Count if there are no records that meet the condition.

    Thanks for helping.