Re: Customized auto-increment serial number

2004-01-25 Thread dread
On 25-Jan-2004 Hassan Shaikh wrote: > Hi, > > I've a unique requirement where the transaction number should be > automatically generated (increment). I can't use AUTO_INCREMENT > column. The TRAN_NO is supposed to be in "MF" format, where: > > Field: TRAN_NO CHAR(10) > > M = Encoded c

Customized auto-increment serial number

2004-01-25 Thread Hassan Shaikh
Hi, I've a unique requirement where the transaction number should be automatically generated (increment). I can't use AUTO_INCREMENT column. The TRAN_NO is supposed to be in "MF" format, where: Field: TRAN_NO CHAR(10) M = Encoded current month (A: January, B: February, C: March . L: De