sql string massaging

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 Received on Tue Sep 05 2006 - 01:35:27 CDT