HELP: REPLACE char throughout entire table

From: Jeff & Dannii <JStiff_at_bigpond.net.au>
Date: Thu, 28 Sep 2000 01:37:50 GMT
Message-ID: <OhxA5.223$Nr3.1872@news-server.bigpond.net.au>

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. Received on Wed Sep 27 2000 - 20:37:50 CDT