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
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