Re: Expertise Requires With Data Extraction

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Tue, 01 Nov 2005 11:32:25 -0600
Message-ID: <na9fm1la6fpa868or6udvblj8njm26hqi2@4ax.com>

fgj001_at_yahoo.com wrote:

>rtrim seems like have a bug -
>
>SQL> select rtrim('POSITION_DATA_A_V','_A_V') from dual;
>
>POSITION_DAT
>
>SQL>
>
>an extra 'A' was removed.

I suspect the _ is causing problems, look at this outcome:

select rtrim('POSITION_DATA_A_V','_A') from dual SQL> / RTRIM('POSITION_D

---

POSITION_DATA_A_V But this:
select rtrim('POSITION_DATA_A_V','_V') from dual

results in ( as expected):

RTRIM('POSITION

---

POSITION_DATA_A Odd..... Received on Tue Nov 01 2005 - 11:32:25 CST