Re: HELP: REPLACE char throughout entire table

Hi,

  If I understand your requirement correctly, the sql that you should   be using would be :

   update docs
   set title = REPLACE (Title, 'a', 'new')    where title like '%a%';

  Let me know if this helps...

In article <OhxA5.223$Nr3.1872_at_news-server.bigpond.net.au>,   "Jeff & Dannii" <JStiff_at_bigpond.net.au> wrote:
> I'm trying to replace a specific character that appears in thousands
 of rows
> throughout the table.
>
> using the SELECT REPLACE... i can return all the affected rows, with
 the
> change made, but i can not seem to get the statement right (if
 possible) to
> actually update the rows. The SELECT REPLACE just displays the rows
> updated, but does not change the table data.
>
> If anyone can help me with this it would be much appreciated.
>
> Example select part of the statement that returns the rows is:
> SELECT REPLACE (Title, 'a', 'new') FROM docs WHERE Title LIKE '%a%'
>
> This also may not be the best way to search and replace all
 occurances of a
> character in a column (Title) of a table (docs)?
>
> Thanks in advance
> Jeff.
>
>

--
Regards
Rajagopal Venkataramany


Sent via Deja.com http://www.deja.com/
Before you buy.