| Function | Description |
|---|---|
| UPPER(s) | Uppercase |
| LOWER(s) | Lowercase |
| LENGTH(s) | String length |
| CONCAT(a,b) | Concatenate |
| TRIM(s) | Remove whitespace |
Lesson 16 of 22 · PostgreSQL
String Functions
Use PostgreSQL string functions UPPER, LOWER, LENGTH, CONCAT and TRIM.
Your challenge
For every user, show their name in upper case and the number of characters in their name: two columns.
Solve it in your browserFree, no sign-up. The PostgreSQL database runs in your browser; your answer is checked instantly, with hints if you need them.