How do I use count and case statement to figure out 'Yes'; 'No'; and null
Salim Jumma
954 628 1487 (work)
954 275 6686 (cell)

-----Original Message-----
From: Jumma Salim
[mailto:mssqldba-ezmlmshield-x39263952.[Email address protected]
Sent: Wednesday, July 27, 2005 3:12 PM
To: LazyDBA Discussion
Subject: some problem

Hello
I am doing a count for a column which has values 'Y';'N', 'Null'
And other columns for which I use group by column

Is it possible if so how do I displays the info as separate column

sj



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page