lundi 12 janvier 2015

How can I change 'WORD' to 'Word' in SQLite?

I am using SQLite as a database. I have a column containing users name.



Name
----
ALEX
DAVID
JOHN
PAUL


How can I amend all rows, so their name is like 'Alex', 'David', 'John', 'Paul' i.e. first letter is uppercase and the rest is lowercase?


Aucun commentaire:

Enregistrer un commentaire