Re: HELP!! String variable manipulation.

From: Rich Rosenberry <Rich.Rosenberry_at_bull.com>
Date: 2000/07/10
Message-ID: <8kcmvv$rb0$1@nntp.bull.com>#1/1

Try

SUBSTR ( strA , 1 , 10 )

Rich

"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 Mon Jul 10 2000 - 00:00:00 CDT