Hi,

String(Varchar) ID generation in Sql Server 2005 & NET

for example ABC01,ABC02...

and

another example IN01,DN02,AM03, PK04,CN05,