Find the Maximum AlphaNumeric number in SQL

by Ravi Tuvar 7:27 PM 0 comments

Hello friends i came with the new post for searching the maximum primary key that is alphanumerical..

so here is the tips to get the maximum alphanumeric value....

Select 'prefix' + convert(varchar(20), max(convert(int, substring(AlphNumField, 4, 100))) + 0) from TableName

now if we want the incremented alphanumeric value then see this one..!


Select 'prefix' + convert(varchar(20), max(convert(int, substring(AlphNumField, 4, 100))) + 1) from TableName 

i hope it would be helpful to you friends...thanks