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: Truncating Certain Charaters

Re: Truncating Certain Charaters

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Thu, 22 Sep 2005 22:35:20 +0200
Message-ID: <8a56j19dc6ojgveg0olgo63h3t5ff7lk68@4ax.com> 





On 22 Sep 2005 07:20:22 -0700, "tobhamlet" <tobhamlet_at_yahoo.ca> wrote:




>

>... that can extract the

>last 5 digits from the STDNT_NUM field. ...




substr(STDNT_NUM,-5)



Jaap.
Received on Thu Sep 22 2005 - 15:35:20 CDT












Original text of this message













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