> Joe, think about usage of existing UDFs or writing own for this
>purpose. But I think it is design mistake - it is more logical and
>simply to store FirstName and LastName and make WholeName computed
>column.

This isn't a design issue. It's just a one-time problem. I have a
customer who accidentally pumped about 8000 names into a single field,
instead of the correct Firstname and Lastname fields. I'm trying to
correct this for him.

Since it's only a one-time deal, I'm trying to find a way to do this with a
minimum of effort, such as a single SQL statement.

-Joe