Re: LTRIM Function (URGENT)

A couple of ways of doing it would be:

This will give everything from the 33rd character to the end of the string:

subsrt(documentno, 33);

or

If the Number always begins with R- and there may be a varying number of spaces and numbers at the beginning you could use:

substr(documentno, instr(documentno, 'R-'));

Kenny Gump

Tay, Virginia wrote in message <_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 - 15:47:27 CDT