> I am looking for an easy way to "SUM" 120 fields in a SELECT statement.

>

> The cursor (Qa) that I wish to "SUM" looks like:

>

> Qa.NUMBER, Qa.WK001, Qa.WK002, Qa.WK003, ........ Qa.WK120

>

> I would like to sort and group this cursor by "NUMBER" into another cursor, but I don't want to repeat the "sum" 120 times.

>

> Example

> SUM(Qa.WK001) as "Wk001", SUM(Qa.WK002) as "Wk002", ...SUM(Qa.WK0120) as "Wk120"

>

> Is there some quick way to sort these fields since they all begin with "WK" and are sequenced with "001" through "120"

>

> Thanks in advance,

>

> Paul D'Anna

Paul

You have already got the solution, but maybe you should recheck your data structure. You will have a lot of trouble if you want to add another WK0121.

Regards

Tushar