Inayotumika kwa UCASE() kwenda SQL

Fomu ya UCASE()

Fomu ya UCASE() inasaidia kubadilisha thamani ya kiini kwa kikuu.

Mafumo ya SQL UCASE()

SELECT UCASE(column_name) FROM table_name

Mifano ya SQL UCASE()

Tunahofaa kusoma tabia hii ya "Persons":

Id LastName FirstName Address City
1 Adams John Oxford Street London
2 Bush George Fifth Avenue New York
3 Carter Thomas Changan Street Beijing

Sasa, tunanaiwa kuachwa kwenye mawasiliano "LastName" na "FirstName", kisha kubadilisha "LastName" kuwa kikuu.

Tumekutumia mafomu ya SQL inayofuata:

SELECT UCASE(LastName) as LastName,FirstName FROM Persons

Matokeo ya mawasiliano inaonekana kama hii:

LastName FirstName
ADAMS John
BUSH George
CARTER Thomas