Re: LTRIM Function (URGENT)
Date: Tue, 13 Jul 1999 15:08:38 GMT
Message-ID: <378B5676.F834E7D8_at_inforonics.com>
If the two values are always delimited by spaces, and you want the second value, then use the following:
update your_table
set documentno = substr(documentno, instr(documentno,' ',-1) +1 ) ;
This says: give me the section of documentno beginning with the first character after the last space in the string through the end of the string.
Test it with a query first to make sure it gives you what you want.
-Jay
"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 - 17:08:38 CEST