TRIM
From SQLZoo
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