Andy Hassall wrote:
> 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
Thanks.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Feb 02 2006 - 14:08:18 CST
