Get Item from Delimited List at Position

  • Chad Casady

    Valued Member

    Points: 62

    Comments posted to this topic are about the item Get Item from Delimited List at Position

  • nigel.

    SSChampion

    Points: 11593

    Another, usually faster, way of splitting a string is with a Tally (or numbers table) see Jeff Moden's article in my signature below.

    Take a look at the method about three quarters of the way through the article, where he compares the loop method with the tally table method you will see that he inserts the results into a temporary table which includes an IDENTITY column. This IDENTITY value can be used in a where clause to get the nth item.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    I getting all of these "list" scripts you wrote. Thanks.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply