Scribd
Upload
6 views7 pages

SQL String Functions Explained

The document outlines various SQL string functions used for manipulating and formatting text data in databases. It provides syntax examples and expected outputs for functions such as CONCAT(), CHAR_LENGTH(), UPPER(), LOWER(), and many others. Each function serves a specific purpose, allowing users to perform tasks like substring extraction, string replacement, and formatting.

Uploaded by

ritikamarotha9
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views7 pages

SQL String Functions Explained

The document outlines various SQL string functions used for manipulating and formatting text data in databases. It provides syntax examples and expected outputs for functions such as CONCAT(), CHAR_LENGTH(), UPPER(), LOWER(), and many others. Each function serves a specific purpose, allowing users to perform tasks like substring extraction, string replacement, and formatting.

Uploaded by

ritikamarotha9
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Program:-7

Aim:- Implementation of various String functions in SQL.


String functions:-
SQL String Functions are powerful tools that allow us to manipulate, format, and extract
specific parts of text data in our database.
Common SQL String Functions
1. CONCAT()
Syntax:-
SELECT CONCAT('RITIKA',' ' ,'MAROTHA') AS FULLNAME;
Output:-

2. CHAR_LENGTH() / CHARACTER_LENGTH()
Syntax:
SELECT CHAR_LENGTH('RITIKA') AS STRINGLENGTH;
Output:

3. UPPER() and LOWER()


Syntax:
SELECT UPPER('ritika') AS UPPERCASE;
SELECT LOWER ('HELLO') AS LOWERCASE;
Output:
4. LENGTH()
Syntax:
SELECT LENGTH('HELLO')AS LENGTHINBYTES;
Output:

5. REPLACE()
Syntax:
SELECT REPLACE('RITIKA MAROTHA','RITIKA','PRAJAPATI') AS UPDATEDSTRING;
Output:

6. SUBSTRING() / SUBSTR()
Syntax:
SELECT SUBSTRING('RITIKA MAROTHA',1,6) AS SUBSTRINGEXAMPLE;
Output:

7. LEFT() and RIGHT()


Syntax:
SELECT LEFT('RITIKA MAROTHA',6)AS LEFTSTRING;
SELECT RIGHT('RITIKA MAROTHA',7) AS RIGHTSTRING;
Output:
8. INSTR()
SELECT INSTR('RITIKA MAROTHA','MAROTHA')AS SUBSTRINGPOSITION;
Output:

9. TRIM()
Syntax:
SELECT TRIM(' ' FROM 'RITIKA MAROTHA')AS TRIMMEDSTRING;
Output:

10. REVERSE()
Syntax:
SELECT REVERSE('RITIKA')AS ReversedString;
Output:

11. ASCII()
Syntax:
SELECT ASCII('T');
Output:

12. CONCAT_WS()
Syntax:
SELECT CONCAT_WS('_', 'RITIKA', 'MAROTHA', 'AIML');
Output:

13. FIND_IN_SET()
Syntax:
SELECT FIND_IN_SET('b', 'a, b, c, d, e, f');
Output:

14. FORMAT()
Syntax:
SELECT FORMAT(0.9912 * 100, 'N2') + '%' AS PercentageOutput;
Output:

15. INSTR()
Syntax:
SELECT INSTR('RITIKA MAROTHA', 'A');
Output:
16. LCASE()
Syntax:
SELECT LCASE ("RITIKA MAROTHA");
Output:

17. LOCATE()
Syntax:
SELECT LOCATE('OF', 'NTHOCCURENCEOFSTRING', 1);
Output:

18. LPAD()
Syntax:
SELECT LPAD('RITIKA', 8, '0');
Output:

19. MID()
Syntax:
SELECT Mid("extract a specific portion",11,8);
Output:
20. POSITION()
Syntax:
SELECT POSITION('I' IN 'RITIKAMAROTHA');
Output:

21. REPEAT()
Syntax:
SELECT REPEAT('Ritika', 2);
Output:

22. REPLACE()

Syntax:
SELECT REPLACE('123-456-123-789', '123', 'ABC') AS Result;
Output:

23. RPAD()
Syntax:
SELECT RPAD('ID', 6, '#') AS Result;
Output:
24. RTRIM()
Syntax:
SELECT RTRIM('Hello ') AS Result;
Output:

25. SPACE()
Syntax:
SELECT CONCAT('X', SPACE(3), 'Y', SPACE(2), 'Z') AS Result;
Output:

26. STRCMP()
Syntax:
SELECT STRCMP('zebra', 'zebra') AS Result;
Output:

You might also like