Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> LTRIM Function (URGENT)

LTRIM Function (URGENT)

From: Tay, Virginia <htay_at_geocities.com>
Date: Mon, 12 Jul 1999 20:22:18 GMT
Message-ID: <_7si3.566$XO2.155@news.flash.net>


Hi,
I would like to trim the following field to be R-13935-01.....Is that a way that get rid of the first 32 characters (First 8 numbers + 24 spaces) by using LTRIM function....

DOCUMENTNO


00003331                        R-13935-01

Please help! THIS IS URGENT!

Thanks a lot!

Virginia Received on Mon Jul 12 1999 - 15:22:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US