UPPERCASE

SELECT CONCAT(UPPER(LEFT(tab.desc_combo, 1)),'',LOWER(SUBSTRING(tab.desc_combo, 2, LENGTH(tab.desc_combo)))) FROM combo_tipo tab; UPDATE combo_tipo SET desc_combo = CONCAT(UPPER(LEFT(desc_combo, 1)),'',LOWER(SUBSTRING(desc_combo, 2, LENGTH(desc_combo)))); SELECT * FROM combo_tipo

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.