Re: HELP: REPLACE char throughout entire table

THANK YOU! I had the FROM docs part of the SELECT REPLACE statement still in there.

Thanks again
Jeff.

"Rajagopal Venkataramany" <net_scan_at_my-deja.com> wrote in message news:8quab7$37s$1_at_nnrp1.deja.com...
> 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.
Received on Wed Sep 27 2000 - 22:03:27 CDT