ms sql table with column with string data which has to be parsed. (Winforms environment)
Posted on 2006-05-31
Table has a column named comb_bill_key varchar (250). Col contains user keys which can be from 1 char in lenght to 8 char in lenght. Data is a number preceded by a " * ".
example of some data---- *1234*2345*3456*87*987
My problem is to parse out each user key and insert it into another (work) table with the identifier from original table. An example would be using data above . if the data above were in record number 1005, then I would like to insert into a work table
REC # user_Key