Re: HELP!! String variable manipulation.

From: Newbie $Joe$ <jranseth_at_hotmail.com>
Date: 2000/07/07
Message-ID: <mMs95.541$Rz1.1432@news1.mts.net>#1/1

Thank you Paul.

"Paul Druker" <pdruker_at_metaway.com> wrote in message news:UJs95.42$gn.7838_at_news1.southeast.rr.com...
> Joe,
>
> You can do it with the SUBSTR function:
>
> strB := substr (strA, 1, 10)
>
> Thanks,
> Paul
>
> "Newbie (Joe)" <jranseth_at_hotmail.com> wrote in message
> news:rNq95.145$Rz1.892_at_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
> >
> >
> >
> >
>
>
Received on Fri Jul 07 2000 - 00:00:00 CDT