Re: Simple SQL question

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Wed, 01 Feb 2006 00:19:43 +0000
Message-ID: <7ivvt1998ncc2f7q49r2s6lnc2inqr2l8n@4ax.com>

On Tue, 31 Jan 2006 15:27:28 -0800, DA Morgan <damorgan_at_psoug.org> wrote:

>Mahesh Rajendran wrote:
>>>>The problem with this approach is you may not know how many layers of
>>>>replace you need.
>>
>> Agreed. And it will not work if there is leading space~!.
>> Thanks
>
>Why is this discussion continuing? Translate will work in all
>situations and is faster.

 TRANSLATE doesn't give the result the poster asked for.

SQL> select translate('the cat sat on the mat', 'A ', 'A')   2 from dual;

TRANSLATE('THECAT

---

thecatsatonthemat

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Tue Jan 31 2006 - 18:19:43 CST