June 28th, 2013, 02:31 PM
Extract Data from field seperated by semi-colons
I have a table that has a field that has been populated with a set of values seperated by a semi-colon
Joyce Price; Sheslie Royster; David Norton
I would like to seperate these into a single field temp table.
The field contains random number of entries.
Thank you in advance for your assistance.
June 29th, 2013, 12:23 PM
you will not be able to do this without some kind of loop
Originally Posted by bholmstrom
it's best handled with application code (asp, c, whatever)
welcome to one of the drawbacks of violating first normal form