Skip to main content

BTRIM

Categories: String

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 (optional): 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

BTRIM example
SELECT BTRIM('      dremio ')
-- dremio
BTRIM example
SELECT BTRIM('~/~/~/dremio~', '~')
-- /~/~/dremio
BTRIM example
SELECT BTRIM('---dremio-', '-')
-- dremio
BTRIM example
SELECT BTRIM('stringvalue', 'string')
-- value
BTRIM example
SELECT BTRIM('pancake pan', 'abnp')
-- cake