Re: HELP!! String variable manipulation.

Joe,

[Quoted] 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 CEST