BTRIM
Trims leading and trailing characters from a string.
Syntax
BTRIM(expression string, trim_text string) → string
expression: String expression to be trimmed.
trim_text: Leading and trailing characters to trim from the input expression. If this parameter is not specified, then spaces will be trimmed from the input expression.
Examples
SELECT BTRIM('spice ')
-- spice
SELECT BTRIM('~/~/~/spice~', '~')
-- /~/~/spice
SELECT BTRIM('---spice-', '-')
-- spice
SELECT BTRIM('stringvalue','string')
-- value
SELECT BTRIM('pancake pan','abnp')
-- cake
Last updated
Was this helpful?