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 -> How to you get rid of the very last character in a string

How to you get rid of the very last character in a string

From: tony <ramdan_at_mailexcite.com>
Date: 28 Jul 1999 16:30:07 -0500
Message-ID: <PCKn3.952$x7.41090@newscene.newscene.com> 





i have a table tha thas a column with names, all of them have either an N or a 
P concatentate to the last word in the field



i.e.  ROGER JONESP


      MARY PEARSONN


i tried rtrim but on the last one it gets rid of both NN 



how do I get rid of just the very last character?
Received on Wed Jul 28 1999 - 16:30:07 CDT












Original text of this message













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