Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## LTRIM

> Removes all the leading characters in `char_expression` that are present in `char_set` and returns the resulting string. The first character in the result is guaranteed not to be in `char_set`. If you do not specify the `char_set` argument, leading blanks are removed.

> #### Syntax

>     LTRIM ( char_expression [ , char_set ] )

> Example

> This example illustrates the `LTRIM` function:

>     SELECT last_name, LTRIM (addr, ' ')
>          FROM customer ;

> #### Notes

> - The first argument to the function must be of type `CHARACTER`.

> - The second argument to the function must be of type `CHARACTER`.

> - The result is of type `CHARACTER`.

> - If the argument expression evaluates to `NULL`, the result is `NULL`.

> - The `char_expression`, the character set specified by `char_set`, and the result can contain multi-byte characters.

> ##### Compatibility

> ODBC compatible

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095