Just so you know... The DelimitedSplit8K that Gail referenced is a super fast string splitting function written by Jeff Moden. You can find the code for it here... Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]