Carl Federl (10/18/2010)
Perhaps I am missing something but what is wrong with a solution that has no cursors, whiles or UDFs ?
Maybe I'm misreading your solution, but it doesn't seem to account for spaces between names. Such as "St. Augustine". Your solution would make it "St. augustine".
I haven't tested this, though. I'm going off what I see.