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_at_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....
Date: Mon, 12 Jul 1999 20:22:18 GMT
Message-ID: <_7si3.566$XO2.155_at_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 - 22:22:18 CEST