John

>don't know why I thought TOP could only be used with
>GROUP BY

Same reason I thought ORDER BY applied on a SELECT by SELECT basis in a UNION - I think its called stupidity

Roy Lambert

ps

I my case it could also be general decrepitude as I age - which in turn causes stupidity

Thanks to all.........
Herb