Re: LTRIM Function (URGENT)

From: James Lorenzen <james_lorenzen_at_allianzlife.com>
Date: Mon, 12 Jul 1999 21:33:37 GMT
Message-ID: <7mdmvg$vsc$1@nnrp1.deja.com>

Virginia: The syntax of the LTRIM function is LTRIM(_string_,’_set_’), so what you would want is:
LTRIM(DOCUMENTNO,'0123456789 ') This will perform as you desired as long as the 33rd position is not a number (or a space). If you will always be stripping the first 32 positions off the column, then this will work (without any possible side effects): SUBSTR(DOCUMENTNO,33) {it skips the first 32 characters and starts with the 33rd and (without a length parameter) goes to the end of the string.

HTH
James

In article <_7si3.566$XO2.155_at_news.flash.net>, "Tay, Virginia" <htay_at_geocities.com> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 12 1999 - 16:33:37 CDT