From: "Paul Druker" <pdruker@metaway.com>
Subject: Re: HELP!!  String variable manipulation.
Date: 2000/07/07
Message-ID: <UJs95.42$gn.7838@news1.southeast.rr.com>#1/1
References: <rNq95.145$Rz1.892@news1.mts.net>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: abuse@rr.com
X-Trace: news1.southeast.rr.com 963008500 24.28.217.226 (Fri, 07 Jul 2000 18:21:40 EDT)
Organization: RoadRunner - Cox
X-MSMail-Priority: Normal
NNTP-Posting-Date: Fri, 07 Jul 2000 18:21:40 EDT
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools


Joe,

You can do it with the SUBSTR function:

strB := substr (strA, 1, 10)

Thanks,
Paul

"Newbie (Joe)" <jranseth@hotmail.com> wrote in message
news:rNq95.145$Rz1.892@news1.mts.net...
> Is there a mid$() function - or equivalent to it - in pl/sql?  I need to
> pull the first X characters from a string, truncating the rest.
> ie:  strA = "very_long_string_variable"
> strB = left(strA, 10)
>
> would result in strB = "very_long_"
>
> Simple idea....can I get some help with the syntax?
>
> Thank you,
> Joe
>
>
>
>