I may have posted this a week or so ago so my apologies for duplicating
the question, but I need some input if anyone can help. Can someone
give me some idea of how to write a trigger that would generate keys
that would look something like this:
abc_def_100. I know that getting the 100 is the easy part, but how does

one preface the number with some other literal that could be a constant
or db derived value??

Thanks,
Lee