select * from #Turnover

select LEFT(location,1),Sum(Total) from #Turnover group by LEFT(location,1)

this was an awesome article on database design................

what a beautiful concept u have posted paul..........i am so happy that i have learned a great thing on your site...........................

so many thanks!!!!!!!!!!!!