Link Search Menu Expand Document

TRIM

Removes all specified characters from the start, end, or both sides of a string. By default removes all consecutive occurrences of common whitespace (ASCII character 32) from both ends of a string.

Syntax

TRIM( [LEADING | TRAILING | BOTH] <trim_character> FROM <expression>)

Parameters

Parameter Description Supported input types
LEADING | TRAILING | BOTH Specifies which part or parts of the <expression> to remove the defined <trim_character>. If unspecified, this defaults to BOTH.

LEADING - trims from the beginning of the specified string

TRAILING - trims from the end of the specified string.

BOTH - trims from the beginning and the end of the specified string.
<trim_character> The characters to be removed. TEXT
<expression> The string to be trimmed. TEXT

Return Type

TEXT

Example

In the example below, no part of the string is specified for TRIM, so it defaults to BOTH.

SELECT
	TRIM('$' FROM '$Hello world$') AS res;

Returns: Hello world

This next example trims only from the start of the string because the LEADING parameter is specified.

SELECT
	TRIM( LEADING '$' FROM '$Hello world$') AS res;

Returns: Hello world$