SQL · String functions

trim() variants

Removes characters from both ends or one side.

sqlRunnable example sql course

Syntax

trim(text, chars) / ltrim() / rtrim()

Example

Open in the lab

SELECT trim('xxhelloxx', 'x') AS trimmed;

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