Hi,

Currently, I am using the following trigger to generate an incremental ID,

create generator pmc_termid_gen;
set generator pmc_termid_gen to 10000;

create trigger create_pmc_termid for pmc_index_list
before insert position 0
as begin
new.termid = gen_id(pmc_termid_gen, 1);
end !!

I am wondering if it is possible change this to generate incremental
alphabets? Something like

create generator pmc_termid_gen;
set generator pmc_termid_gen to 'aaaaa';

Thanks and cheers
Maurice