Substitute a Character - Mailing list 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!!!




pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Query regarding to MS reporting services (Grand total problem)
Next
From: Andreas Kretschmer
Date:
Subject: Re: Substitute a Character