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.