Substring type query

[aqif]

Hi

I've got a query which gives me output like:

Stage CountofStage
1a 5
1b 3
2a 6
2b 4
3a 2

Instead of this I want an output in a grouping manner like

Stage CountofStage
1 8 (5+3)
2 10
3 2

i think that maybe Substring fuction will work..but dont know how to...n one thing is that Stage will never be greater than 9 like u'll never have a stage like 10a

Cheers!
Aqif