Name

trim — Trim white space from the beginning and ending of a string.

Syntax

trim(string)
              

The TRIM function has the following argument:

string

The string to be trimmed.

Description

Return a string identical to the input string but with leading and trailing white space characters removed.

Input strings that do not have leading or trailing white space are returned unchanged.

Examples

Formula

Description

Result

trim(' Hello ')

Return the trimmed version of ' Hello '

'Hello'