Facing problem Increamenting by one in Sql Server Field whose data type in character

Dec 27 2011 12:52 AM

I have data base field intr_prod_id char(10) Now i want to generate the Primary key like IP-1. After 1P-10 it will not increamenting.
I write the Query for this above id Generation IP-10. It will increaming upto 10 after that it will not increamenting