Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Strange RTRIM Function behaviour

Strange RTRIM Function behaviour

From: George Ferenc <georgef_at_lonelyplanet.com.au>
Date: Thu, 17 Aug 2000 11:03:14 +1000
Message-ID: <8nfdjt$c0m$1@perki.connect.com.au> 






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 Wed Aug 16 2000 - 20:03:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US