Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Monday 27 July 2015

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

No comments:

Post a Comment

Please provide your feedback in the comments section above. Please don't forget to follow.