BTRIM function
The BTRIM function trims a string by removing leading and trailing blanks or by removing characters that match an optional specified string.
Syntax
BTRIM(string [, matching_string ] )
Arguments
- string
-
The first input parameter is a VARCHAR string.
- matching_string
-
The second parameter, if present, is a VARCHAR string.
Return type
The BTRIM function returns a VARCHAR string.
Examples
The following example trims leading and trailing blanks from the string '
abc '
:
select ' abc ' as untrim, btrim(' abc ') as trim; untrim | trim ----------+------ abc | abc (1 row)
The following example removes the leading and trailing 'xyz'
strings
from the string 'xyzaxyzbxyzcxyz'
select 'xyzaxyzbxyzcxyz' as untrim, btrim('xyzaxyzbxyzcxyz', 'xyz') as trim; untrim | trim -----------------+----------- xyzaxyzbxyzcxyz | axyzbxyzc (1 row)
Note that the leading and trailing occurrences of 'xyz'
were removed,
but that occurrences that were internal within the string were not removed.