Remove spaces from the left, right, or both sides.

Section: String Functions

Trim whitespace

sql
sql
SELECT TRIM(name) AS cleaned_name
FROM customers;
Explanation

LTRIM and RTRIM are also available in many engines.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing String Functions
Concatenate strings
Join multiple strings into one value.
OpenIn sheetsqlsame section
Change case
Convert strings to uppercase or lowercase.
OpenIn sheetsqlsame section
Extract substring
Return part of a string.
OpenIn sheetsqlsame section
Replace text
Substitute one substring for another.
OpenIn sheetsqlsame section
Get current date and timestamp
Return the current date and current timestamp.
Use CASE expression
Return different values based on conditions.