Re: LTRIM Function (URGENT)

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Tue, 13 Jul 1999 07:47:46 -0400
Message-ID: <378B2761.87261B12@Unforgettable.com>

If you want to get rid of the first 32 characters do it like this

select substr(myfield,32) from mytable;

Ken

"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
Received on Tue Jul 13 1999 - 06:47:46 CDT