Available Tables

Next →

String Functions (UPPER, LOWER, TRIM, SUBSTRING, REPLACE)

SQL provides built-in string functions to manipulate text data easily.

Common String Functions

Example: Clean and Format Names

To display student names in uppercase and remove extra spaces:

SELECT UPPER(TRIM(name)) FROM students;

You can combine functions to format or clean data for reports and analysis.

Try using these functions to manipulate text fields in your queries!