Re: sql string massaging

On 05.09.2006 08:35 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
>

substr()

See:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/functions119a.htm#87068

-- 
It's not a RootKit - it's a Sony