Quote:
Originally Posted by Dante Hicks
|
I don't know for certain, but I suspect that that wouldn't work. The description of REPLACE states that it replaces one string with another only when outputting the query result to the outside world. It sounded as though the threa poster wanted to actually alter the values stored in the database itself. REPLACE would not do this. It might fool you since everytime you queried the database it would return what you expect so long as you left the REPLACE in there, but if you removed the REPLACE it would return to what was originally in the database. If this is all you need the go for it, if you are trying to actually alter what is stored in the database then you will probably need to write a script that alters each row in the database. Shouldn't be too difficult, a couple of lines of code at best.