zOs/SQL/MFTST

select count(*), left(MF150023, 1)
    from oa1a.tmf150a1
    where  MF150013 between '25.06.2010' and '05.07.2010'
    group by left(MF150023, 1)
    with ur