What made you doubt that? <bg>

>Sergey, you're still a SQL-genius. Thanks!
>
>
>>John,
>>
>>Try
>>

>>SELECT ig.ItemGroup, SUM(Cost) AS SumCost
>>	FROM ( SELECT Item AS ItemGroup FROM po p1
>>			WHERE NOT EXISTS ( SELECT 1 FROM po
>>				WHERE p1.Item <> Item AND p1.Item LIKE Item + '%')
>>		) ig JOIN po ON po.Item LIKE ig.ItemGroup + '%'
>>	GROUP BY ig.ItemGroup
>>

>>
>>>
>>>I keep thinking there should be an easy way to query for what I need but just can't come up with anything so here it goes.