Re: sql string massaging

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 5 Sep 2006 17:41:23 +0200
Message-ID: <44fd9aa3$0$4738$626a54ce@news.free.fr>

<soalvajavab1_at_yahoo.com> a écrit dans le message de news: 1157438127.593175.275100_at_m79g2000cwm.googlegroups.com...
| 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
|

I asked the same question to my students. I think you can find the answer among the character functions in SQL Reference.

Regards
Michel Cadot Received on Tue Sep 05 2006 - 10:41:23 CDT