TRIM
Removes leading and trailing whitespace from the given input string.
Syntax
TRIM(STRING)
Arguments
STRING
Type: string
A sequence of characters.
Returns
Type: string
STRING with any leading or trailing whitespaces removed.
Examples
| STRING | Output |
|---|---|
abc
|
abc
|
abc
|
abc
|
abc
|
`abc |
abc a
|
abc a
|
ab c a
|
ab c a
|
ab c a 3
|
ab c a 3
|
''
|
|
null
|
null
|