Re: Expertise Requires With Data Extraction

From: HansF <News.Hans_at_telus.net>
Date: Tue, 01 Nov 2005 18:35:06 GMT
Message-Id: <pan.2005.11.01.19.33.42.456879@telus.net>

On Tue, 01 Nov 2005 09:24:00 -0800, fgj001 amused us by writing:

> 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 wonder if underscore being 'single character wild card' in SQL has anything to do with it?

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting guarantees I will not respond further ***

Received on Tue Nov 01 2005 - 12:35:06 CST