Re: Replace in table

From: andrewst <member14183_at_dbforums.com>
Date: Tue, 26 Aug 2003 08:28:39 -0400
Message-ID: <3285192.1061900919@dbforums.com>

Originally posted by Detlef Jockheck

> Hi,

> how can I replace "a" with "abc" in a column? I would prefer a sql-
> solution.

> eg:

> column_old

> a

> hda

> jkaj

> column_new

> abc

> hdabc

> jkabcj

> ciao

> Detlef

Unsurprisingly, you would use the REPLACE function:

SELECT REPLACE(column_old,'a','abc') AS column_new FROM mytable;

--
Posted via http://dbforums.com

Received on Tue Aug 26 2003 - 07:28:39 CDT