Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id DB1A89FBA13 for ; Thu, 12 Apr 2007 01:32:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 42208-02-8 for ; Thu, 12 Apr 2007 01:32:18 -0300 (ADT) X-Greylist: delayed 01:15:46.636304 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 0FE729FBB55 for ; Thu, 12 Apr 2007 01:19:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from ns2.instrumentalyst.com (blk-222-55-203.eastlink.ca [24.222.55.203]) by svr4.postgresql.org (Postfix) with ESMTP id 950615AFBDB for ; Tue, 10 Apr 2007 20:41:00 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by ns2.instrumentalyst.com (Postfix) with ESMTP id 6A48D142B for ; Tue, 10 Apr 2007 17:27:41 -0300 (ADT) X-Virus-Scanned: amavisd-new at instrumentalyst.com Received: from ns2.instrumentalyst.com ([127.0.0.1]) by localhost (ns2.instrumentalyst.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id LZDe9jexliKx for ; Tue, 10 Apr 2007 17:27:34 -0300 (ADT) Received: from murdoc.home (pool-71-180-50-145.tampfl.fios.verizon.net [71.180.50.145]) by ns2.instrumentalyst.com (Postfix) with ESMTP id E93F0130A for ; Tue, 10 Apr 2007 17:27:33 -0300 (ADT) Message-ID: <461BF649.70204@productivitymedia.com> Date: Tue, 10 Apr 2007 16:40:41 -0400 From: PostgreSQL Admin User-Agent: Thunderbird 2.0b2 (Macintosh/20070116) MIME-Version: 1.0 To: PostgreSQL SQL List Subject: Replace string Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200704/123 X-Sequence-Number: 28123 Hi, I want to replace a title with dashes and also remove punctuation. e.g, The blue fox's fur. -> The-blue-fox-fur Thanks for any input, J