Specify arguments to the TRIM function

The TRIM function is a built-in SQL function that removes leading or trailing pad characters from character strings of 255 or fewer characters. By default, this pad character is ASCII 32, the blank space.

If your locale supports a code set that defines a different white space character, TRIM does not remove this locale-specific blank space from the front or back of a string. If you specify the LEADING, TRAILING, or BOTH keywords for TRIM, you can specify a different pad character.

You cannot, however, specify a non-ASCII character as a pad character, even if your locale supports a code set that defines the non-ASCII character.