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

Home -> Community -> Usenet -> c.d.o.tools -> Re: pls help w/data conversion

Re: pls help w/data conversion

From: Ian Brown <browni_at_globalnet.co.uk>
Date: Sun, 22 Jul 2001 12:52:31 +0100
Message-ID: <tllf6rcsbma44c@xo.supernews.co.uk> 






Maybe something like:




decode(substr(namefield,length(namefield),1),'s',namefield||'''',namefield)



Interpretation:



check for 's' as the last character. If so, append a single quote to end, if
not leave in original form.



Regards,



Ian
Received on Sun Jul 22 2001 - 06:52:31 CDT












Original text of this message













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