Re: sql string massaging

From: Paulie <plinehan_at_yahoo.com>
Date: 5 Sep 2006 05:55:01 -0700
Message-ID: <1157460901.588477.292990@m79g2000cwm.googlegroups.com>

soalvajavab1_at_yahoo.com wrote:

> we have bunch of tables which has cutomer names in one column, now we
> need to separate them as firstname, middlename and lastname and then
> transfer them to new target table. can you please give me the string
> conversion command/procedure which can do that..many thanks

Very very difficult! Depends on many factors - what about double-barrelled
names, not separated by a hyphen? Will SUBSTR() assume that one is the middle name? What about people with 5 names? What about people who use apostrophe's? How would you separate John-Joe O'Shea Ua h'Úigín?
I think you're going to have to do it programatically with some sort of

human intervention - pay a student to do it for a few hours - how many customers do you have?

Paul... Received on Tue Sep 05 2006 - 07:55:01 CDT