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

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

From: Paul Q <paulq_at_home.com>
Date: Wed, 28 Jul 1999 21:58:12 GMT
Message-ID: <U1Ln3.14627$um6.163701@news2.rdc1.on.home.com> 






field := substr(field,1,length(field)-1)



tony wrote in message ...


>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:58:12 CDT












Original text of this message













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