On 15 May 2003 at 16:44, Don Gollahon wrote:

>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

Try Group by SC, substring(INDICATORS from 28 for 1)

You also can use a calculated field or a view as was already
suggested.

SY, Dimitry Sibiryakov.