http://codeinet.blogspot.com/2006/08/split-string-using-recursive-sql.html looks okay to me, anthony, nice one ;o) brian, too bad you aren't using mysql, which has a lovely function called SUBSTRING_INDEX that, well, never mind, it's wonderful but you can't use it...