Re: Strange RTRIM Function behaviour

From: Joerg Bruewer <joerg_at_bruewer.de>
Date: Thu, 17 Aug 2000 11:06:49 +0200
Message-ID: <399BAB29.8D9A63F2@bruewer.de>

the RTRIM command looks for any combination of the letters.

To find out the effect, change for example: 'Wharf TheatrX, The' or
'Wharf TheatTe, The'
the results are:

                'Wharf TheatrX'
and
                'Wharf Thea'

i thing you will understand !

peace and a long life
joerg

George Ferenc schrieb:

> I am running Oracle 8i 8.1.6 on SOlaris 2.7.
>
> When running the following statement
>
> select rtrim(a.name, ', The')
> from (select 'Wharf Theatre, The' as name from dual) a;
>
> I get 'Wharf Theatr' as a result.
>
> Shouldn't I get 'Wharf Theatre'? Is this a bug or expected behaviour?
>
> George
Received on Thu Aug 17 2000 - 04:06:49 CDT