asp, auto generate number

[kumiko]

hi there..i need some guidance and help again in another problem..
i would like to do a autogenerate order number.
ok..i wan the format is liek this:

order prefix+ order number

the order prefix is ABC-KL while the order number is SELECT the latest ordernumber id from the tables. let say the final order number is 2000, then the next order number will be 2001.
then in the asp coding there..how can i build this function to generate this auto number?

plz give some response and help..thanx alot