How do I do this query:

Select
SC
, substring(INDICATORS from 28 for 1) as IND28
, cast(sum(CABS_MSGS) as integer) as Cabs_Msgs
, cast(sum(ACCESS_TIME) as numeric(15,2)) as AccMins
from master
where
(data_source = 'CAB')
and (source_id = 2003032117)
Group by SC, IND28

Group By does not accept field #'s (like 2).




Don Gollahon