Should not be too difficult if there is always a blank as delimiter.
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=17517 might give you some ideas
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]