Replacing text in a table field

Sometimes it is necessary to replace some of your known data with something else. For example if you have the word Downtown you may want to say CBD instead. In SQL you can do this using the replace directive. select name=replace(name, 'Downtown', ...

by admin  April 3rd, 2008