Purpose
This function deletes all of the characters specified in the expression, trim_string, from both the right and left border of string.
Syntax
trim::=
or
trim::=
Usage Notes
- If
trim_stringis not specified, then the spacing characters are deleted. - You can use either of the syntax diagrams.
Example
Copy
SELECT TRIM('abcdef', 'acf') "TRIM";
SELECT TRIM(LEADING '1' FROM '1234567891');
SELECT TRIM(TRAILING '1' FROM '1234567891');
SELECT TRIM(BOTH '1' FROM '1234567891'); 