i've got a table on sql that holds over 9000 names they are all one string i.e. mr j j Smith, etc.
i need to read the table into a dataset split the string then feed that data into a new dataset can you help me????
once i've done that i need to update another table using the diferent columns.
any idea's have tried the obvious one of filling a dataset the using a split function but i don't know where to go after that any ideas?
