Loading

How to separate int and string values in a table?

Renjith V S

12y1.2k

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Renjith V S12y ago
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.
0
Abhijeet Singh12y ago
Check this link..

http://stackoverflow.com/questions/19885076/how-to-split-string-and-insert-values-into-table-in-sql-server

it may be helpful
0