Re: search/replace in update

Gary,

> This means that e.g. all mobile numbers that used to start 0589 now 
> start 07889.
> 
> Is there a way in SQL to update the phone number in-place?

Postgresql has a nifty string substitution function.  For this and other
character manipulation functions, see:

http://www.postgresql.org/idocs/index.php?functions-string.html

You should be able to fairly easily swap out "07889" and replace it with
"0589".

-Josh



______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco