you are at Encyclopedia of SQL >> UCASE()
UCASE(`column_name`)
Function returns value of text column uppercase.Syntax
SELECT UCASE(`column_name`)
FROM `table_name`
Example
Display all surnames uppercase
name | surname | age |
---|---|---|
Paweł | Kowalski | 3 |
Piotr | Janik | 7 |
Michał | Nowak | 13 |
query
SELECT UCASE(`surname`)
FROM `people`
result
UCASE(`surname`) |
---|
KOWALSKI |
JANIK |
NOWAK |