Don,

> 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).

either create a view or stored procedure and
group by SC and IND28 when querying the view
or stored procedure.

Firebird 1.5 supports GROUP BY <field_index>



Regards,
Thomas Steinmaurer
http://www.iblogmanager.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com