O’zbekiston Respublikasi Oliy va o’rta maxsu ta’lim vazirligi Samarqand Davlat Universiteti Raqamli texnalogiyalar fakulteti

SELECT Ism, UCase(Ism) AS UCase_Ism

FROM Talabalar

LEFT() funksiyasi yordamida matndagi dastlabki uchta belgini qirqib olish:

SELECT Ism,LEFT(Ism, 3) AS LEFT_Ism

FROM Talabalar

MID() funksiyasi sintaksisi:

MID(maydon_nomi, boshlanuvchi_belgi_o‘rni, olinadigan_belgilar_soni)

SELECT Ism,MID(Ism, 3, 3) AS MiD_Ism

FROM Talabalar


LEN funksiyasi yordamida POYTAXTI maydonidagi yozuvlar uzunliklarini aniqlash

SELECT Ism,LEN(Ism) AS LEN_Ism

FROM Talabalar

Natijaga e’tibor bersak hech qanday o‘zgarish bo‘lmadi.

SELECT Ism,LEN(Ism) AS LEN_Ism, LTrim (Ism) AS LTrim_Ism, LEN (LTrim_Ism) AS LEN_LTrim

FROM Talabalar

2.