SQL · Functions and expressions

trim()

Removes spaces from both ends. Use ltrim or rtrim for one side.

sqlRunnable example sql course

Syntax

trim(text)

Example

Open in the lab

SELECT trim('  spaced  ') AS trimmed;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.