HTMLify

Q1667_Fix_Names_in_a_Table.sql
Views: 172 | Author: djdj
SELECT user_id, CONCAT(UPPER(LEFT(name,1)),LOWER(SUBSTRING(name,2))) AS name
FROM Users 
ORDER BY user_id;

Comments