The Trim () function gets a string and the position at which spaces are to be removed is passed as a parameter and returns this string without any relevant spaces.

Trim('String', 'Positions')

Possible positions are

• l for left-sided blanks,
• r for right-hand blank spaces and
• b for blanks on both sides

that are to be removed.

Trim(' 12345 ', 'r')

returns ' 12345'

Trim(' 12345 ', 'l')

returns '12345 '

Trim(' 12345 ', 'b')

returns '12345'