How to separate int and string values in a table?

Question

Hi I have a table named Itemdetails. There is a column named ItemCode it is initialised as varchar(50). So I entered both int and string values to the column. Now I need to use auto increment operation for the integer values in the column. So I need to get max(ItemCode)+1 value. For that I need to seperate string and int values. Thanks

Renjith V S · Answer

Its not answer. I need to get the max (id) of inserted value. But I heard that varchar doesn't support integers it converts integer to string. To get the auto generated value it should be int.

Abhijeet Singh · Answer

Check this link.. http://stackoverflow.com/questions/19885076/how-to-split-string-and-insert-values-into-table-in-sql-server it may be helpful