InterSystems SQL Reference
end_keyword] [ string-expression-1] FROM string-expression-2)
|end_keyword||Optional A keyword specifying the which end of string-expression-2 to strip. Available values are LEADING, TRAILING, BOTH. The default is BOTH.|
|string-expression-1||Optional The string expression specifying the characters to strip from string-expression-2. Every instance of the specified character is stripped. Thus 'abc' strips 'bbbaacaaa'. If not specified, TRIM strips spaces.|
The string expression which will be stripped. Both string expressions can be the name of a column, a string literal, or the result of another function, where the underlying data type can be represented as any character type (such as CHAR or VARCHAR2).
|LEADING||A keyword that specifies that the characters in string-expression-1 are to be removed from the beginning of string-expression-2.|
|TRAILING||A keyword that specifies that the characters in string-expression-1 are to be removed from the end of string-expression-2.|
|BOTH||A keyword that specifies that the characters in string-expression-1 are to be removed from both the beginning and end of string-expression-2. BOTH is the default and is used if no end_keyword is specified.|