Open In App
Related Articles

LCase() and UCase () Function in MS Access

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Report issue
Report
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 –
LowercaseName
gfg

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 –
UppercaseName
GFG

Last Updated : 28 Aug, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads