+ 3

SQL UPPER function

Can you please help me? I tried everything, I don't know how to run the UPPER function The UPPER Function You are given the following staff table Write a query to output the firstname and the lastname columns into one column named uppercasename separated by a space and converted to uppercase.

17th Jul 2021, 5:57 PM
Irina Iulia Laska BA
Irina Iulia Laska BA - avatar
3 Réponses
+ 6
Upper(table_colomn) Pls Post your try ,,how you are trying.. that may help to find correction... you can use concat function to combine..
17th Jul 2021, 6:27 PM
Jayakrishna 🇮🇳
+ 2
SELECT CONCAT (UPPER(firstname),' ',UPPER(lastname)) As uppercasename FROM staff;
24th Jul 2021, 6:00 AM
Tenzing Shema
Tenzing Shema - avatar
0
Thanks @Tenzing Shema, I was trying something similar but it didn't work. I tried SELECT CONCAT UPPER(firstname, ' ', lastname) AS uppercasename FROM staff; and SELECT CONCAT (firstname, ' ', lastname) AS UPPER (uppercasename) FROM staff; It seems that these functions have some kind of logical hierarchy that I am not aware of. Hopefully I will gradually become aware of it.
28th Jan 2022, 4:32 PM
Daniel Alberto Rojas Cuchigay
Daniel Alberto Rojas Cuchigay - avatar