From: "Newbie \(Joe\)" <jranseth@hotmail.com>
Subject: HELP!!  String variable manipulation.
Date: 2000/07/07
Message-ID: <rNq95.145$Rz1.892@news1.mts.net>#1/1
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: admin@mts.net
X-Trace: news1.mts.net 963000535 205.200.66.197 (Fri, 07 Jul 2000 15:08:55 CDT)
Organization: MTS Internet
X-MSMail-Priority: Normal
NNTP-Posting-Date: Fri, 07 Jul 2000 15:08:55 CDT
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools


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