Update Fix_Names_in_a_Table.sql

Rakshitgupta9 · web-flow · commit 477b954c5600 · 2024-07-12T16:28:22.000+05:30
diff --git a/Advanced_String_Functions_Regex_Clause/Fix_Names_in_a_Table.sql b/Advanced_String_Functions_Regex_Clause/Fix_Names_in_a_Table.sql
@@ -0,0 +1,6 @@
+SELECT user_id, 
+CONCAT(UPPER(LEFT(name, 1)), 
+LOWER(RIGHT(name, LENGTH(name) - 1))) 
+AS name 
+FROM Users 
+ORDER BY user_id;
