TRIM

Syntax:

TRIM ( string )

Description: Makes a string that is a copy of string with the leading and trailing space characters removed, and each sequence of embedded spaces reduced to a single space. The space character referred to here is character U+0020.

Arguments:

Name

Type

Description

string

text

Designates the string to be trimmed.

Return Type and Value: text – The trimmed copy of string.

example: