Hello, I have just started using SQL SERVER 2000 and I need urgent help on setting default values. Lets say I have 2 fields: 1.AID Integer (Identity) 2.ACHAR Character (6) I'd like the default value of ACHAR to be a string like 'E00001', 'E00002', 'E00003'... where the digit part of the string comes from AID. I need this character based ID because it is an official ID (e.g. Employee ID). How I can I have this done most efficiently is SQL SERVER? I seem not be able to do an inline default value using any combination of the str, ltrim, convert, cast functions. I have used ORACLE extensively in the past. This was a breeze using nextval etc Can someone tell me how to do this in SQL SERVER? Thanks a million for your help.. Gracie Many many thanks for your help.