hi,
      i have a tble named "student" where the there is say 2 fields, student_id and student_name. the id should be incremented by 1 automatically and a Prefix say "DU" should be attached with it. the table should be like this

   student_id student_name
   DU001 x
   DU002 y
   DU003 z

Am not able to increment the Student_id field due to the Charachter DU. Plz guide me hw can it be done in SQL server

add a field called PK to your table, set it as a primary key, int, auto increment; the student_id field has to be a varchar (obviously) and when you go to insert data into that table set the a variable to the pk:

Set @pk = (SELECT MAX(pk) from [table])

That will return you the highest number now all you need to do is add the DU and pad it with the necessary rows.

hth.

"The one language all programmers understand is profanity."