Generate number series

Jun 19 2009 12:10 PM
Hi All,

I want to generate a number series which contains both letters and digits. And it should be generated automatically.

Ex:- Assume we have 3 codes-->    APR   BDL  JAF
       Then number series should be  APR000001, APR00002, APR00003...........
                                                         BDL00001,BDL00002.........

It's like a receipting number series. Under these numbers, records will be saved. And I want to save this series in the sql database.

How can I do this......???

Should I do this in coding or can I do this using SQL....???

I'm using VS2008, C# language, SQL 2005

It's a big help if u can help me....



Answers (1)