Removes the longest string containing only characters in <trim_characters> from both sides of the source string <expression>. If no <trim_characters> parameter is specified, the longest string containing only whitespace characters (ASCII Decimal 32) is removed from both sides of the specified source string <expression>.
Syntax
BTRIM(<expression>[, <trim_characters>])
Parameters
| Parameter | Description | Supported input types |
|---|
<expression> | An expression that returns the string to be trimmed. | TEXT |
<trim_characters> | Optional. An expression that returns characters to trim from both sides of the <expression> string. If omitted, whitespace (ASCII Decimal 32) is trimmed. | TEXT |
Return Type
TEXT
Examples
The following example trims the character x from both sides of a string:
SELECT BTRIM('xxThe Acceleration Cupxxx', 'x') AS result;
| result text |
|---|
| The Acceleration Cup |
Rows: 1Execution time: 5.48ms
x and y from both sides of a string. Note that the ordering of characters in <trim_characters> is irrelevant:
SELECT BTRIM('xyxyThe Acceleration Cupyyxx', 'xy') AS result;
| result text |
|---|
| The Acceleration Cup |
Rows: 1Execution time: 4.59ms
<trim_characters> parameter, and thus trims whitespace from both sides of a string:
SELECT BTRIM(' The Acceleration Cup ') AS result;
| result text |
|---|
| The Acceleration Cup |
Rows: 1Execution time: 5.64ms
