Re: LTRIM Function (URGENT)

From: Dave <DaveTati_at_Sprynet.com>
Date: Mon, 12 Jul 1999 18:04:39 -0400
Message-ID: <7mdonl$lsa$1@nntp9.atl.mindspring.net>

Hi,

Another possible solution is to use RTRIM if the R-13935-01 is always in the same format, ie 10 characters.

HTH.
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 - 17:04:39 CDT