LCase() and UCase () Function in MS Access

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

My Personal Notes arrow_drop_up

Save