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