Trim whitespace

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.

Same sheet · prioritizing String Functions

Join multiple strings into one value.

Open In sheetsqlsame section

Convert strings to uppercase or lowercase.

Open In sheetsqlsame section

Return part of a string.

Open In sheetsqlsame section

Substitute one substring for another.

Open In sheetsqlsame section

Return the current date and current timestamp.

Return different values based on conditions.