I think this is exactly what you are looking for: http://www.sqlteam.com/item.asp?ItemID=256
Eric Dobris -----Original Message----- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 2:52 PM To: CF-Talk Subject: string parsing or list traversal Does anyone know how to traverse a list of prse a string in T-SQL inside a stored procedure? What I need to do i send a comma delimited list into a stored proc then loop over the list inserting each entry into a table. Any help would be appreciated. Thanks, Michael T. Tangorre ---------------------------------------- MillenniuM Information Systems 1101 Wilson Blvd. Suite 1200 Arlington, Virginia 22209 O: 703-341-1438 C: 607-426-9277 ---------------------------------------- Golden Rule: "He who has the gold, makes the rules!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4