E-mail Print PDF

SELECT LCASE(column_name) FROM table_name

Пример SQL

P_IdLastNameFirstNameAddressCity
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger

1
SELECT LCASE(LastName) as LastName,FirstName FROM Persons

Query Result:

LastNameFirstName
Ola
Tove
Kari

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Translate

русскийitalianoDeutschEnglishLATVIANукраїнськаfrançaispolski
1

Advertisement