Should/Can I use Sequence for this ?

Hi Gurus,

I have to maintain computer generated document numbering where the number format is :

  xx123456789

xx : is the department code
123456789 : document number counter per department

How can I maintain this number ?
Can I use sequence for this ? or should I manually maintain(increment) it in a document highest number table per dept code ?

Thank you for your help,
xtanto Received on Sun Sep 26 2004 - 11:27:27 CDT