Re: translate function

From: Chris Weiss <chris_at_hpdbe.com>
Date: Wed, 15 May 2002 16:31:05 -0400
Message-ID: <abugie$2tu5$1@msunews.cl.msu.edu>

Try the replace function:

devdb2l.elnsng1.mi.home.com::select replace('abcdef','a') from dual;

REPLA

---

bcdef

devdb2l.elnsng1.mi.home.com::ed
Wrote file afiedt.buf

  1* select replace('abcdefa','a') from dual evdb2l.elnsng1.mi.home.com::/

REPLA

---

bcdef

Good Luck!

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Chris Weiss
mailto:chris_at_hpdbe.com
www.hpdbe.com
High Performance Database Engineering
Available for long and short term contracts

"Luciano Belotto" <luciano_at_nospam.com> wrote in message
news:abufe4$qp5_at_dispatch.concentric.net...


> I want to do something with translate function, i broke it down to this to

> ask my question:

>

> select translate('abcdef', 'a', 'A') from dual;

> returns Abcdef, which is fine

>

> But

> select translate('abcdef', 'a', '') from dual;

> I would think this would return: bcdef but it just returns blank (or

null?).


> Is this correct? Is there a way (or another similar, easy way) to get it

to


> return what I want?

>

> --

> Luciano Belotto

> replace spam with traxsoftware for e-mail

>

>

Received on Wed May 15 2002 - 15:31:05 CDT