> I have a table (see below) where I want to combine the two totals below into the 0304KZ6 total so that I can end up with something like the second example.
>
> current 0304KZ6 6786.11
> 0304KZ6RR 3750.41
>
> desired 0304KZ6 10536.52
> 0304KZ6RR 0.00
>
> Any help/direction is greatly appreciated.
>
> Thank you very much and have a great day!

GROUP BY on SUBSTRING?

Won't be that fast out-of-the box on a huge table, but it might be
improved by a function-based index.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/