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 -> Truncating Certain Characters

Truncating Certain Characters

From: tobhamlet <tobhamlet_at_yahoo.ca>
Date: 22 Sep 2005 07:20:34 -0700
Message-ID: <1127398834.404016.181710@g14g2000cwa.googlegroups.com>

Is there any way in Oracle to only extract a certain number of charaters from a field.

For example, I have a student number field (STDNT_NUM), and some student numbers start with an S, such as

89187
S56789
S78900

I want a query that can either exclude the S, or that can extract the last 5 digits from the STDNT_NUM field. So, the data will look like this,

56789
78900

Is there a way to do this in Oracle?

Marcus


Received on Thu Sep 22 2005 - 09:20:34 CDT

Original text of this message

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