...btw, sorry to the original poster!
I wasn't aware of the PARSENAME function.
Sounds really handy for such situations.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]