SQL String Functions – SQL Tutorial | Software Testing Material
SQL String Functions:
In this post, we see SQL String Functions in detail.
LEN() – It returns the length of the value in a text field
LOWER() – It converts character data to lower case
UPPER() – It converts character data to upper case
SUBSTRING() – It extracts characters from a text field
LTRIM() – It is to remove all white space from the beginning of the string
RTRIM() – It is to remove all white space at the end of the string
CONCAT() – Concatenate function combines multiple character strings together.
REPLACE() – To update the content of a string.
Let’s see each String function in detail.
LEN():
Syntax:
SELECT LEN(column_name) FROM table_name;
Example:
SELECT LEN(Playername) AS LengthPlayername FROM SCOREBOARD WHERE Playername = 'Sachin';
LOWER():
Syntax:
SELECT LOWER(column_name) FROM table_name;
Example:
SELECT LOWER(Playername) AS Playername FROM SCOREBOARD WHERE Playername = 'Sachin';
UPPER():
Syntax:
SELECT UPPER(column_name) FROM table_name;
Example:
SELECT UPPER(Playername) AS Playername FROM SCOREBOARD WHERE Playername = 'Sachin';
SUBSTRING() :
Syntax:
SELECT SUBSTRING(column_name,start,length) AS some_name FROM table_name;
Example:
SELECT SUBSTRING(Playername, 3, len(Playername)) AS Playername FROM SCOREBOARD WHERE Playername = 'Sachin';
LTRIM:
Syntax:
SELECT LTRIM(Playername) FROM SCOREBOARD;
RTRIM:
Syntax:
SELECT RTRIM(Playername) FROM SCOREBOARD;
CONCAT:
Syntax:
SELECT City+Country from CUSTOMERS;
REPLACE:
Syntax:
SELECT REPLACE (City, 'C', 'ZZZZ') FROM CUSTOMERS;
Check out the complete SQL Tutorial by clicking on below link:
