hi everybody,
    I have to know that how to generate the Identity with Alphabets like (bc00001,gsa00001).How to write the code in SQL Server 2000.Thanks In Advance.
Regards
Srinivasan.R

There is no way to auto generate alphanumric identity, you have to do it manually.
First you must fix length of alpha chars and length of numeric chars.

eg.
student table

STUDCODE STUDNAME
STD00001 Ramesh Mehta
STD00002 Samir Patel


Here alpha length is 3 and number length is 5
Declare @newnumber INTEGER
DECLARE @newstdcode varchar(8)

--find max number
SELECT @newnumber=ISNULL(MAX(substring(STUDCODE,4,8)),0)+ 1 FROM STUDENT

--prepare your code by padding 0's
@newstdcode ='STD'+replicate('0',5-len(str(@newnumber,5,0)))

INSERT INTO STUDENT (STUDCODE,STUDNAME) VALUES (@newstdcode,'New Student name')

urt

And, just to note... having a code that looks like STD00001 is the absolute worst practice you can have because there is the eventuality of needing to recycle numbers because the current format of the code only allow 99,999 unique numbers. Really bad practice...

--Jeff Moden