DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
LEFT
|
|
LOWER
|
|
PROPER
|
|
RIGHT
|
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’.