TRIM

The TRIM function enables you to trim leading or trailing characters (or both) from a character string.

You can also trim leading characters using LTRIM and trailing characters using RTRIM.

Return Value

The data type of the string you are trimming (that is, trim-source).

Syntax

TRIM ([{{LEADING|TRAILING|BOTH} [trim_character])|trim_character} FROM] trim_source)

Arguments

trim-character

An expression that specifies the values to be trimmed. This text expression can be any of the text data types. When you do not specify a value, then the default value is a blank space and the function removes leading and trailing blank spaces.

LEADING

Specifies that the function removes any leading characters equal to trim_character.

TRAILING

Specifies that the function removes any trailing characters equal to trim_character.

BOTH

Specifies that the function removes leading and trailing characters equal to trim_character.

trim-source

An expression that is the value to be trimmed. This text expression can be any of the text data types.