Last updated 1 year ago
Was this helpful?
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
Trims leading and trailing characters from a string.
SELECT BTRIM('spice ') -- spice
SELECT BTRIM('~/~/~/spice~', '~') -- /~/~/spice
SELECT BTRIM('---spice-', '-') -- spice
SELECT BTRIM('stringvalue','string') -- value
SELECT BTRIM('pancake pan','abnp') -- cake