Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!news.tele.dk!feed118.news.tele.dk!postnews.google.com!s53g2000cws.googlegroups.com!not-for-mail
From: "gazzag" <gareth@jamms.org>
Newsgroups: comp.databases.oracle.server
Subject: Re: How to obtain only xx char
Date: 7 Jul 2006 07:03:09 -0700
Organization: http://groups.google.com
Lines: 15
Message-ID: <1152280989.158883.293190@s53g2000cws.googlegroups.com>
References: <44ae68cb$0$5100$4fafbaef@reader2.news.tin.it>
NNTP-Posting-Host: 193.130.12.157
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1152280992 6833 127.0.0.1 (7 Jul 2006 14:03:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 7 Jul 2006 14:03:12 +0000 (UTC)
In-Reply-To: <44ae68cb$0$5100$4fafbaef@reader2.news.tin.it>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: s53g2000cws.googlegroups.com; posting-host=193.130.12.157;
   posting-account=zujbXgsAAAA8hne0tKRbNp7NAGtNgEwN
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270572

Identity wrote:
> Hi! I've a field varchar2(100)... how can I obtain only the  from 4th  to
> 7th char??
>
> Thanks

Look up the SUBSTR function in your SQL Reference manual.  That will do
what you want.

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions162.htm#i87066

HTH

-g