sql / beginner
Snippet
Standardizing String Casing with UPPER and LOWER Scalar Functions
Scalar functions like LOWER and UPPER transform individual column values into lowercase or uppercase, helping normalize text representation across outputs.
snippet.sql
sql
1
2
SELECT LOWER(email) AS normalized_email, UPPER(status) AS uppercase_statusFROM users;
Breakdown
1
SELECT LOWER(email) AS normalized_email, UPPER(status) AS uppercase_status
Applies LOWER to convert email addresses to lowercase and UPPER to turn status codes to uppercase.
2
FROM users;
Specifies the table containing the source records to format.