SELECT GCBW, BHQK, BCHT, ADD_CLJE, BCHTQK, LEFT(STATION,4) ; FROM KYGCGL GROUP BY 6 ORDER BY 6 ; WHERE 'U'$UPPER(GCBH) >>
>SELECT KYGCGL.GCBW ,KYGCGL.BHQK ,KYGCGL.BCHT ,KYGCGL.ADD_CLJE ,KYGCGL.BCHTQK ,; > SUBSTR(KYGCGL.STATION,1,4) FROM KYGCGL GROUP BY (SUBSTR(KYGCGL.STATION,1,4)); > ORDER BY (SUBSTR(KYGCGL.STATION,1,4)) WHERE AT(UPPER('U']),UPPER(GCBH))>0 >