TRIM | LTRIM | RTRIM
The TRIM
function removes both leading and trailing spaces from the
specified string. LTRIM
removes just leading spaces, and RTRIM
removes just trailing spaces.
Syntax
TRIM | LTRIM | RTRIM(string_expression)
Return Value
Returns a string value without leading and/or trailing spaces.
Input Parameters
string_expression
Required. A dimension attribute or expression that returns a string
value.
Examples
TRIM(" hello world ") returns "hello world"
LTRIM(" hello world ") returns "hello world "
RTRIM(" hello world ") returns " hello world"