Returns a character string after truncating all leading blanks and trailing blanks.
Oracle and PostgreSQL has additionally specifying what you want to remove leading, trailing or both (default is both and blanks).
With SQL server you have to use a combination of LTRIM() and RTRIM().

TRIM() function

Returns a character string after truncating all leading blanks and trailing blanks.
Oracle and PostgreSQL has additionally specifying what you want to remove leading, trailing or both (default is both and blanks).
With SQL server you have to use a combination of LTRIM() and RTRIM().