Btrim

String Function

Description

Removes leading and trailing characters from a string.

Click here to navigate to the PostgreSQL docs page for this syntax.

The function Btrim() is translated to Trim() in Snowflake.

Grammar Syntax

BTRIM(string TEXT, pattern TEXT)

Sample Source Patterns

PostgreSQL

Code

SELECT BTRIM('XXXSampleXXX', 'XXX');

Result

Snowflake

Code

SELECT TRIM('XXXSampleXXX', 'XXX');

Result