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.