SQL LOWER FUNCTION

LOWER function in SQL converts all the input characters in LOWER case.

Syntax :-

SELECT LOWER(INPUT STRING);

EXAMPLE:-

SELECT LOWER('CHANCHAL WANKHADE') as LOWER_exaple;

Result:-  chanchal wankhade

Here are five frequently asked questions about the LOWER function in Microsoft SQL Server (MSSQL), along with their answers:-

1. What does the LOWER function do in MSSQL?

   - The LOWER function in MSSQL converts all characters in a string to lowercase.

2. How do I use the LOWER function in MSSQL?

   - You can use the LOWER function by providing the string you want to convert to lowercase as an argument. For example:

     

     SELECT LOWER('Hello World');

     

     This query would return 'hello world'.

3. Is the LOWER function in MSSQL case-sensitive?

   - No, the LOWER function in MSSQL is not case-sensitive. It converts all characters to lowercase regardless of their original case.

4. Can I use the LOWER function with column values in a table in MSSQL?

   - Yes, you can use the LOWER function with column values in a table. For example:

     

     SELECT LOWER(ColumnName) FROM TableName;

     

     This query would return the values of the column ColumnName in lowercase for each row in the table TableName.

5. Does the LOWER function modify the original string or return a new string in MSSQL?

   - The LOWER function in MSSQL returns a new string with all characters converted to lowercase. It does not modify the original string. If you want to store the lowercase version, you need to assign it to a new variable or column.

Read Also:- LOWER function in ORACLE