Funksi UCASE() SQL

Funksiya UCASE()

Funksiya UCASE() yana kawar da mutumciyar gudanarwar zuwa tsakiyar mai suna.

Farki SQL UCASE()

SELECT UCASE(column_name) FROM table_name

Amfani SQL UCASE()

A na da wannan "Persons" table:

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

Tun dake nuna, a baya a nemi kiyaminta "LastName" da "FirstName", kuma a kawar da "LastName" zuwa tsakiyar mai suna.

A na fiwa yankin SQL:

SELECT UCASE(LastName) as LastName,FirstName FROM Persons

Kiyaminta yana kusa da wannan:

LastName FirstName
ADAMS John
BUSH George
CARTER Thomas