quote:
This may seem easy, but is rife with potential problems. My last name is two words...
...and to complicate it a little bit, I guess you don't have a middle name, right?
Anyway, the original error was to store these informations in a single column. And, of course, it will leave always some rest of work for you to do, but it's easier once the data is in separate columns.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]