Re: What is use of trim

rohityogi_at_yahoo.com (Rohit Yogi) wrote in message news:<ed793cc1.0404300242.1987abcd_at_posting.google.com>...
> I have few scripts which use rtrim, ltrim & trim.
>
> I want to know what is use of these functions what do the do.
>
> 1 example of SQL is:
>
> update ARRANGEMENT set DOCUMENT=trim(DOCUMENT);
> commit;

To "trim" off any leading (ltrim) or trailing (rtrim) spaces.

So that if, in your example above,
If DOCUMENT = ' hello world '
The result, after the trim would be:
DOCUMENT = 'hello world' Received on Fri Apr 30 2004 - 19:35:27 CEST