Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 76267 invoked from network); 2 Nov 2005 10:08:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 2 Nov 2005 10:08:53 -0000 Received: (qmail 99370 invoked by uid 500); 2 Nov 2005 10:08:51 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 99335 invoked by uid 500); 2 Nov 2005 10:08:51 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 99326 invoked by uid 99); 2 Nov 2005 10:08:51 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Nov 2005 02:08:51 -0800 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=NO_REAL_NAME,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of cedric.maucourt1@mpsa.com designates 194.250.98.246 as permitted sender) Received: from [194.250.98.246] (HELO mail-s.mpsa.com) (194.250.98.246) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Nov 2005 02:08:46 -0800 Received: from aigz1.domino.inetpsa.com ([172.21.41.61]) by mail-s.mpsa.com (Unknown version) with ESMTP id <0IPB00FXSO5DE0@pydu62.inetpsa.com> for derby-dev@db.apache.org; Wed, 02 Nov 2005 11:08:02 +0100 (MET) Date: Wed, 02 Nov 2005 11:07:59 +0100 From: cedric.maucourt1@mpsa.com Subject: Characters replacement function To: derby-dev@db.apache.org Message-id: MIME-version: 1.0 X-Mailer: Lotus Notes Release 6.0.1CF1 March 04, 2003 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable X-MIMETrack: Serialize by Router on AIGZ1.DOMINO/S/PSA(Release 6.0.2CF2 HFB2 PSA_2 THTO68YUBB TTRT69EUV5 THTO63SRTD MIAS6F4JQE|Aug 11, 2005) at 02/11/2005 11:07:50 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hello, First I apologize for my poor english... I'm looking for a simple way to implement a character replacement funct= ion. I'm trying to do an application migration from WSAD/DB2 to Tomcat/Derby= but there are a lot of SQL queries which use the REPLACE(SOURCE STRING, OLD= CHARACTER, NEW CHARACTER) function. It seems that this function is not built into Derby. Do you have an idea? Best regards C=E9dric=