generating 0000 increment

[galvatron]

yo yo yo my gods in the house. please tell me how do I do this with asp and sql. I need to make a product ID that starts with 0000 and increments. not automatically though. It's I do one table with the 0000 value, everytime I add 1 it goes 0001 0002 0004 till 9999. so howsitgoes? please meng. aight thanks in advance.

[galvatron]

upping. please peoples I need this.

[Zebulin]

oldid = rs("id") '0000 ?

newid = right("0000" & (cint("0" & oldid) + 1) ) ' 0001 !


what say..

[sunpost]

close...

newid = Right("0000" & (CInt(oldid) + 1), 4 )

[galvatron]

thanks a lot guys.