在Derby DDL中如何将字符串和数字连接为标识

I've looked everywhere in the last 3 hours but still can't get this to work. I need to be able to concatenate the 1prefix and 1suffix value to form an id consisting of string and number.I've looked everywhere in the last 3 hours but