Re: Substitute a Character

On 9/6/06 12:53 PM, "Judith" <jaltamirano(at)correolux(dot)com(dot)mx> wrote:

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

select translate( 'A98526', 'A', '0' );

translate
------------
098526

1 record(s) selected [Fetch MetaData: 1/ms] [Fetch Data: 0/ms]

[Executed: 9/6/06 4:18:44 PM EDT ] [Execution: 99/ms]

>
> Thanks in advanced!!!
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

--
Daryl
Email *my = [ daryl at: @"eddl" dot: @"us" ];
Weblog *blog = @²http://itsallsemantics.com²;