X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 0E6829FB370 for ; Wed, 6 Sep 2006 17:25:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 45677-03 for ; Wed, 6 Sep 2006 20:25:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from alnrmhc11.comcast.net (alnrmhc11.comcast.net [206.18.177.51]) by postgresql.org (Postfix) with ESMTP id 270FC9FB332 for ; Wed, 6 Sep 2006 17:25:24 -0300 (ADT) Received: from [10.0.1.3] (unknown[71.225.71.211]) by comcast.net (alnrmhc11) with SMTP id <20060906202022b11001pjone>; Wed, 6 Sep 2006 20:20:22 +0000 User-Agent: Microsoft-Entourage/11.2.5.060620 Date: Wed, 06 Sep 2006 16:20:37 -0400 Subject: Re: Substitute a Character From: Daryl Richter To: Judith , Message-ID: Thread-Topic: [SQL] Substitute a Character Thread-Index: AcbR8eoCKK+Aqz3lEdupgwARJOT9EA== In-Reply-To: <44FEFCFA.8010501@correolux.com.mx> Mime-version: 1.0 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/38 X-Sequence-Number: 26249 On 9/6/06 12:53 PM, "Judith" wrote: > Hello everybody!! > =20 > I have a field type text with folios like this: A98526 >=20 > but I want to change de A for a 0 like this: 098526, exists a way to > do this in a query??? select translate( 'A98526', 'A', '0' ); translate =20 ------------=20 098526 =20 1 record(s) selected [Fetch MetaData: 1/ms] [Fetch Data: 0/ms] [Executed: 9/6/06 4:18:44 PM EDT ] [Execution: 99/ms] >=20 > Thanks in advanced!!! >=20 >=20 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend -- Daryl Email *my =3D [ daryl at: @"eddl" dot: @"us" ]; Weblog *blog =3D @=B2http://itsallsemantics.com=B2;