TRIM Function

Parameters (String);

Returns: String

Removes whitespace at the start of or at the end of the input string and outputs the result.

The parameter is the input string

If the input string is NULL, NULL will be returned.

The examples below show some examples of how this function can be used.

Example 1:  TRIM(' Hello World') = 'Hello World'

Example 2:  TRIM('Hello World') = 'Hello World'

Example 3:  TRIM(NULL) = NULL

Example 4:  TRIM('Hello World\n   ') = 'Hello World' (\n is a return character)