Skip to content

String and byte trimming

RETURN TRIM(BOTH 'x' FROM 'xxnamexx') AS name, BTRIM('xynameyx', 'xy') AS trimmed;

TRIM supports simple and standard LEADING/TRAILING/BOTH forms. BTRIM/LTRIM/RTRIM support optional trimming character sets, including multi-character forms in the parser. Byte-string forms are also recognized. This is separate from TRIM(list, count).

See supported features for executable alternatives.