TRIM
Syntax
<trim-expression> := 'TRIM(' <String> ')'
Since
2.2.6
Return-type
String
Description
The function TRIM ommits all leading and trailing whitespaces from the input string passed as arguments. If the argument is NULL the function also returns NULL.
Examples
TRIM( ' Hello World ' )
= 'Hello World'
See also
LTRIM, RTRIM
