conversion from nvarchar to int in sql-2005

[2911]

hi to all,

i had declared a variable as nvarchar in sql-2005.
lr( nvarchar) -- hyd pd 0000001 hyd ---it will be saved.
but it will be auto generated value in asp.net front end.
like hyd pd 0000002 hyd ,hyd pd 0000003 hyd , ....
for auto increment i can using max( lr )+1.

i got the error like:: Conversion failed when converting the nvarchar value 'hyd pd 00000001 hyd' to data type int

please give me solution

[kenobewan]

You are not able to convert letters to an integer, split the string before converting the numbers to integer and then add. HTH.