Received: from stan.ringways.co.uk ([213.38.87.130]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5E8eUE80671 for ; Thu, 14 Jun 2001 04:40:31 -0400 (EDT) (envelope-from gary.stainburn@ringways.co.uk) Received: from gary.ringways.co.uk ([10.1.1.2] ident=gary) by stan.ringways.co.uk with smtp (Exim 3.13 #1) id 15ASbx-0003FO-00 for pgsql-sql@postgresql.org; Thu, 14 Jun 2001 09:36:17 +0100 Content-Type: text/plain; charset="iso-8859-1" From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-sql@postgresql.org Subject: search/replace in update Date: Thu, 14 Jun 2001 09:40:34 +0100 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <01061409403400.06009@gary.ringways.co.uk> Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/205 X-Sequence-Number: 3463 Hi all, here in England OFTEL, the governing body for all things telephone recent hand another phone number dialing code change (one of many). 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? -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000