Re: LTRIM Function (URGENT)
From: MWeb <jasonh_at_yebo.co.za>
Date: Mon, 12 Jul 1999 23:12:30 +0200
Message-ID: <378a5b62.0_at_news1.mweb.co.za>
Date: Mon, 12 Jul 1999 23:12:30 +0200
Message-ID: <378a5b62.0_at_news1.mweb.co.za>
Try using the SUBSTR fucntion...
Tay, Virginia <htay_at_geocities.com> wrote in message
news:_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 - 23:12:30 CEST