Re: ltrim() in Oracel 8.1.6

From: Kirmo Uusitalo <kirmo.uusitalo.no.spam_at_iki.fi>
Date: Tue, 23 Apr 2002 09:46:39 +0300
Message-ID: <mn0acugo1mmtj4s78stmlq9q9i8him64pr@4ax.com>

On 22 Apr 2002 20:27:32 -0700, zhuwang_at_yahoo.com (zhuwang) wrote:

>here are the output of several ltrim(), I really don't understand what
>is the purpose of ltrim(). How can I get the following results?
>Need your help and thanks.
>
>SQL> select ltrim('ascsa','asc') from dual;
>L
>-

SQL> select ltrim('__test__','_t') from dual;

LTRIM

est__

LTrim is normally used to remove space characters from the left of the string, but it accepts the 2nd parameter in which to specify which characters to remove from the start of the string.

HTH, Kirmo Uusitalo Received on Tue Apr 23 2002 - 01:46:39 CDT