Re: LTRIM Function (URGENT)

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 12 Jul 1999 21:48:21 +0800
Message-ID: <3789F225.7670@yahoo.com>

Tay, Virginia 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

What is wrong with SUBSTR ?

x := substr(documentno,33)

will get all characters from 33 onwards...

If you don't know where the "R-" appears, then you use INSTR

x := substr(documentno, instr(documentno, 'R-'));

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Jul 12 1999 - 08:48:21 CDT