FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What function can be used to display names in lower case?
A
LEFT
B
LOWER
C
PROPER
D
RIGHT
Explanation: 

Detailed explanation-1: -It converts uppercase letters to lower case for the specified text or expression. Let’s use some examples and view the output of this function.

Detailed explanation-2: -The LOWER() function converts a string to lower-case.

Detailed explanation-3: -The lower() method converts all uppercase characters in a string into lowercase characters and returns it.

Detailed explanation-4: -Use the SQL LOWER() function if you want to convert a string column to lowercase. This function takes only one argument: the column whose values you want to lowercase. This function is a good choice if your database is case sensitive and you want to select only records matching a particular string.

Detailed explanation-5: -How to make a string lowercase in Python? Using a Python built-in string method lower() on the string or a variable representing it. For example, ‘PythoN’. lower() will return ‘python’.

There is 1 question to complete.