Substitute a Character

From: Judith <jaltamirano(at)correolux(dot)com(dot)mx>
To: pgsql-sql(at)postgresql(dot)org
Subject: Substitute a Character
Date: 2006-09-06 16:53:14
Message-ID: 44FEFCFA.8010501@correolux.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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!!!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2006-09-06 17:09:12 Re: Substitute a Character
Previous Message Andrew Sullivan 2006-09-06 11:31:13 Re: Query regarding to MS reporting services (Grand total problem)