|
|
|
|
|
|
BTRIM removes the longest string consisting only of specified characters from the start and end of a string.
Syntax
BTRIM ( expression [ , characters-to-remove ] )
Semantics
expression |
(CHAR or VARCHAR) is the string to modify |
characters-to-remove |
(CHAR or VARCHAR) specifies the characters to remove. The default is the space character. |
Examples
BTRIM('xyxtrimyyx', 'xy')
Result: trim