Re: string manipulation

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Sun, 23 Sep 2001 11:43:06 -0000
Message-ID: <tqs43d6bvg8bcd@corp.supernews.com>

Try
select 'NORTH'||column from table;

to change
update table set column = 'NORTH'||column where column = 'VALUE';

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"ed zappulla" <zappullae_at_rcn.com> wrote in message news:9ol1he$b29$1_at_bob.news.rcn.net...
> does any know how th replace the first char or a field with a string using
> sql plus?
>
> I want to take all "N FOOBAR" and make it "NORTH FOOBAR".
>
>
>
Received on Sun Sep 23 2001 - 06:43:06 CDT