• sorry,

    here

    create table GLCTA

    (

    IDN char(4),

    KARA char(2),

    KCTR char(2),

    DCAT varchar(50) not null

    )

    go

    insert into GLCTA

    select '0099','01','06','Eme3Prodcat2x'

    union all

    select '0099','01','07','Eme4Prod'

    union all

    select '0099','02','07','Eme4Prod'