SQLite Lower() Function

  Total Views : 259
  Comments : 0
  Keywords : SQLite lower() function to convert characters to lowercase, SQLite convert column values to lowercase using lower() function with example

Here we will learn Lower() function in SQLite and how to use SQLite Lower() function to convert given string characters to lowercase with examples.

SQLite Lower() Function

In SQLite lower() function is used to convert given text to lowercase or specified string characters to lowercase.

 

In case if the given string contains other than letters means those characters won’t effect with this lower() function.

Syntax of SQLite Lower() Function

Following is the syntax of SQLite lower() function to convert given string characters to lowercase.

 

lower( string )

In above SQLite lower() function syntax we defined few parameters those are

 

string – Its source string which is used to convert string characters to lowercase.

 

Now we will see how to use SQLite lower() function to convert specified string characters to lowercase with examples.

SQLite Lower() Function Examples

Following are the simple examples of SQLite Lower() function to convert specified string characters to lowercase.

 

sqliteSELECT lower('WELCOME to Tutlane!!!');

 

lower("WELCOME to Tutlane!!!")

-------------------------------

welcome to tutlane!!!

 

sqliteSELECT lower('TUTlane!!!123');

 

upper("TUTlane!!!123")

-------------------------------

tutlane!!!123

SQLite Lower Function with Table Column

Now we will see how to use SQLite lower() function with tables to convert columns data to lowercase. Consider we have table called “test” with following records.

 

sqliteSELECT from test;

 

i

----------

SHWETA

SHWETS

SHWATI

VINAY

VIJAY

VIVEK

Now we will update test table column i value with lower() function to convert values to Lower case like as shown following.

 

sqlite> UPDATE test setlower(i);

Now we will check the records of test table using following SELECT statement.

 

sqliteSELECT from test;

 

i

----------

shweta

shwets

shwati

vinay

vijay

vivek

This is how we can use SQLite Lower() function to convert given or specified string text or characters to lowercase based on our requirements. 

 Comments (0)

Be the first to give your valuable feedback

Leave a comment

  • Default Tutlane User