#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Philadephia
    Posts
    16
    Rep Power
    0

    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

    Example:

    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.
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,150
    Rep Power
    4274
    Originally Posted by bholmstrom
    I would like to seperate these into a single field temp table.
    you will not be able to do this without some kind of loop

    it's best handled with application code (asp, c, whatever)

    welcome to one of the drawbacks of violating first normal form
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo