Translations:Faq/Base/126/7/en

    From The Document Foundation Wiki
    • The function TRIM removes one or more characters at the beginning or end of the string. Specify whether leading, trailing, or both with the keywords LEADING, TRAILING, or BOTH (default).
    • Similarly there are functions LTRIM and RTRIM which specifically remove spaces from the left and right respectively of the expression given as the parameter.
    • These function can be used in both draft and SQL mode.
    • In the example given, no keyword specifying position is given therefore the default BOTH will be applied.