BTRIM
Removes the longest string consisting only of specified characters from the start and end of a string.
Behavior Type
Syntax
BTRIM ( expression [ , characters-to-remove ] )
Parameters
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. |
Example
=> SELECT BTRIM('xyxtrimyyx', 'xy');
BTRIM
-------
trim
(1 row)