Problem in getting MAX value from table

• • Reply

  12 years ago

  by royal ludhiana

  Royal Ludhiana

  Toronto, Canada

  Joined 14 years ago

  hi all,

  I have a field named  pkLocationCd with size nchar(5). I am using the following sql command to get the max+1 value through this:

  select isnull(max(pkLocationCd)+1,1) from tbLocationMaster

  This works fine for upto 10 records, i.e. I am able to insert 10 records easily, but when I try to insert 11th record it shows me an error. After debugging I found out that the value I am getting is 10 with max+1..........where as it should be getting 11.

  can you suggest me where I am going wrong?

  Regards,

  Royal

  Report abuse
• • Reply

  12 years ago

  by royal ludhiana

  Royal Ludhiana

  Toronto, Canada

  Joined 14 years ago

  Hi guys,

  I got the solution as soon as I posted this problem. the solution is:

  select max(convert(int,pkLocationCd)+1) from tbLocationMaster

  I only had to convert it to int.

  Regards,

  Royal

  Report abuse