Scalar function
NULL subject returns NULL; an empty subject remains empty.
Syntax
Scalar
Custom characters (scalar)
- In the two-argument form, pass the characters to remove first and the text to trim second: (characters, subject).
Arguments
Scalar
Custom characters
Returns
- Type: STRING
- NULL behavior: NULL subject returns NULL; an empty subject remains empty.
Properties
Usage notes
- The one-argument form removes space characters.
- Deterministic: The same inputs and settings produce the same result.
Examples
Typical behavior
Choose the characters to remove
In the two-argument form, the characters to remove come first.
Limitations
- In the two-argument form, pass the characters to remove first and the text to trim second: (characters, subject).
Last modified on October 15, 2026
