Upper case first in SQL SELECT
This query selects a string from database containing both upper case (STOCKHOLM) and lower case (stockholm) characters and present it as upper case first (Stockholm), and removes duplicates.
<?php
$sql = "SELECT DISTINCT CONCAT(UPPER(LEFT(LOWER(city_name), 1)), SUBSTRING(LOWER(city_name), 2)) AS city FROM city WHERE 1";
?>