TRIM(string_exp)

Returns the characters of string_exp with both leading and trailing blanks removed.

 

Example:

SELECT TRIM(' ABCDE ') returns ABCDE