SELECT
RTRIM(Name),
LTRIM(Name),
TRIM(Name)
FROM country
| RTRIM(Name) | LTRIM(Name) | TRIM(Name) |
| Aruba | Aruba | Aruba |
| Afghanistan | Afghanistan | Afghanistan |
| Angola | Angola | Angola |
| Anguilla | Anguilla | Anguilla |
| Albania | Albania | Albania |
| Andorra | Andorra | Andorra |
| Netherlands Antilles | Netherlands Antilles | Netherlands Antilles |
| United Arab Emirates | United Arab Emirates | United Arab Emirates |
| Argentina | Argentina | Argentina |
| ... |
| RTRIM() function trims all spaces from the right of a value. LTRIM() function trims all spaces from the left of a value. TRIM() function trims both the right and left. |