SQL question -Reply

Rick Try this select count ( distinct column1) fromtablefoo rgds -- -- Peter Tashkoff <tashkop@kiwi.co.nz> NZ Kiwifruit Marketing Board Usual disclaimers apply. This posting may not be used by any party to vilify another. >>> rickt <rickt@wybbs.mi.org> 18/October/1996 11:12am >>> If I have the following SQL select column1, count(*) from tablefoo group by column1 It returns 24 rows with various counts. Is there a way to return just the number of rows that would have been returned. (ie just the number 24) I know I could put it in a temp table and then count that but, yuk -- Rick Tucker rickt@wybbs.wynalda.com -- I try to take one day at a time..., but lately several days have attacked me at once. --