From: "Newbie \(Joe\)" <jranseth@hotmail.com>
Subject: Re: HELP!!  String variable manipulation.
Date: 2000/07/07
Message-ID: <mMs95.541$Rz1.1432@news1.mts.net>#1/1
References: <rNq95.145$Rz1.892@news1.mts.net> <UJs95.42$gn.7838@news1.southeast.rr.com>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: admin@mts.net
X-Trace: news1.mts.net 963008658 205.200.66.197 (Fri, 07 Jul 2000 17:24:18 CDT)
Organization: MTS Internet
X-MSMail-Priority: Normal
NNTP-Posting-Date: Fri, 07 Jul 2000 17:24:18 CDT
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools


Thank you Paul.

"Paul Druker" <pdruker@metaway.com> wrote in message
news:UJs95.42$gn.7838@news1.southeast.rr.com...
> 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
> >
> >
> >
> >
>
>