LCase() and UCase () Function in MS Access
Last Updated :
28 Aug, 2020
1. LCase() Function :
In MS Access the LCase() function converts the text to lowercase from uppercase. In this function, a string is passed as a parameter and it will return the string in lowercase as a result.
Syntax :
LCase(text)
Example –
SELECT LCASE("GeekForGeeks")
AS LowercaseName
Output –
LowercaseName |
geeksforgeeks |
Example –
SELECT LCASE("GFG")
AS LowercaseName
Output –
2. UCase() Function :
It works like LCase() function but it converts the given string in the uppercase. In this function, a text will be passed and it will return the string in uppercase.
Syntax :
UCase(text)
Example –
SELECT UCASE("GeekForGeeks")
AS UppercaseName
Output –
UppercaseName |
GEEKSFORGEEKS |
Example –
SELECT UCASE("gfg")
AS UppercaseName
Output –
Share your thoughts in the comments
Please Login to comment...