TRIM

Compatibility

TRIM(s)
Engine	OK	Alternative
ingres	Yes
mysql	Yes
oracle	Yes
postgres	Yes
sqlserver	No	LTRIM(RTRIM(s))

TRIM

TRIM(s) returns the string with leading and trailing spaces removed.

   TRIM('Hello world  ') -> 'Hello world'

This function is particularly useful when working with CHAR fields. Typically a CHAR field is paddded with spaces. In contrast a VARCHAR field does not require padding.

SELECT name,
       LTRIM(RTRIM(name))
  FROM bbc

SELECT name,
       TRIM(name)
  FROM bbc

See also

• SUBSTRING function
• LEFT function
• RIGHT function