InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 09:56:34 GMT20http://www.sqlservercentral.com/Forums/Topic1075983-2913-1.aspxAnother, 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.Thu, 10 Mar 2011 05:55:17 GMTnigel.http://www.sqlservercentral.com/Forums/Topic1075983-2913-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/UDF/72559/">Get Item from Delimited List at Position</A>[/B]Wed, 09 Mar 2011 20:57:40 GMTChad Casady