HOW? Sequencing primary key appended with a character.

Please how can one sequence the primary key each time to create a tuple.

Examples

     supplier# value is  S1001
     the next should automatically be  s1002 on creation.

Thanks in Advance.

Hilary Juma. Received on Tue Nov 26 1996 - 00:00:00 CET