On 9/6/06 12:53 PM, "Judith" <[EMAIL PROTECTED]> 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²; ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
