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 C88579FB3AD
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  6 Sep 2006 13:53:08 -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 87075-04-5 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  6 Sep 2006 16:53:04 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from CORREO.correolux.com.mx
	(customer-200-79-53-218.uninet-ide.com.mx [200.79.53.218])
	by postgresql.org (Postfix) with ESMTP id 0F9339FB3B3
	for <pgsql-sql@postgresql.org>; Wed,  6 Sep 2006 13:52:34 -0300 (ADT)
Received: from [192.168.7.58] ([192.168.7.58]) by correolux.com.mx with
	MailEnable ESMTP; Wed, 06 Sep 2006 11:56:00 -0600
Message-ID: <44FEFCFA.8010501@correolux.com.mx>
Date: Wed, 06 Sep 2006 11:53:14 -0500
From: Judith <jaltamirano@correolux.com.mx>
User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317)
X-Accept-Language: es-es, es
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Substitute a Character
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.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200609/35
X-Sequence-Number: 26246

    Hello everybody!!  
   
    I have a field type text with folios like this: A98526

    but I want to change de A for a 0 like this: 098526, exists a way to 
do this in a query???

    Thanks in advanced!!!