STRING Function in SQL - Explain the STRING Function with Example in SQL|STRING Function in SAP HANA

 

String Function - SAP HANA 

1. LOCATE

2. LOWER, UPPER

3. LCASE , UCASE

4. LEFT , RIGHT

5. REPLACE

6. LPAD , RPAD

7. SUBSTRING , SUBSTRING_AFTER , SUBSTRING_BEFORE

8. TRIM, LTRIM , RTRIM

9. LENGTH 

10. CONCAT

11. ASCII

12. CHAR , NCHAR 

13. UNICODE

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

1. LOCATE

 SELECT LOCATE (‘HELLO SQL’, ‘SQL') "locate" FROM DUMMY;

RESULT - 7

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

2. LOWER, UPPER

3. LCASE , UCASE

SELECT upper ('Hello') "upper" FROM DUMMY;

   Result = HELLO

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

4. LEFT , RIGHT

SELECT RIGHT (‘SAP Learning academy' , 2) FROM DUMMY;

   Result = my

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

5. REPLACE

SELECT Replace ('SAP learning academy', 'SAP', 'SQL') FROM DUMMY;

   Result = SQL learning academy

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

6. LPAD , RPAD

SELECT RPAD ('SQL','6', 'A') FROM DUMMY;

   Result = SQLAAA

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

7. SUBSTRING , SUBSTR_AFTER , SUBSTR_BEFORE

SELECT SUBSTRING ('SQL LEARNING ACADEMY','5','2') FROM DUMMY;

   Result =  LE

SELECT SUBSTR_before ('SQL LEARNING ACADEMY','LEARNING') FROM DUMMY;

   Result =  SQL

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

8. TRIM, LTRIM , RTRIM

 SELECT TRIM( '   SQL    A  ' ) FROM DUMMY;              

Result = SQL  A

 SELECT  TRIM ( 'XXX' FROM 'XXXABCDEXXX')  FROM DUMMY;

   Result =  ABCDE

 SELECT  LTRIM ('XXXABCDEXXX' , 'X')  FROM DUMMY;

   Result =  ABCDEXXX

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

8. ASCII

  SELECT ASCII( 'SQL' ) FROM DUMMY;

Result = 83

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

12. CHAR , NCHAR 

   SELECT nCHAR( '83' ) FROM DUMMY;;

Result = S

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

13. UNICODE

   SELECT UNICODE( '?' ) FROM DUMMY;

Result = 63

----------------------Watch Below Video Explanation ----------------------