Change case

sql

SELECT UPPER(email) AS email_upper, LOWER(email) AS email_lower
FROM users;

Explanation

Useful for case-insensitive comparisons and normalized reporting.

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

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

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.