SQL Tutorial for Data Analysis 18: String Related Functions

In this lesson we’re going to learn how to use some common scalar functions that operate on string values.

Key concepts to remember -
* The RIGHT() function Extracts N characters from a string (starting from right)
* The LEFT() function extracts characters from the left side of a string
* The LEN() functions Returns the length of a string
* The REPLACE() function replaces all occurrences of a substring within a string
* The REVERSE() function simply reverses a string
* The SUBSTRING() function Extracts characters from a string
* The LOWER() function returns a string in a lower case
* The UPPER() function returns a string in upper case

Course Examples -
https://ramkedem.com/en/sql-basics-examples/

ACDB Database -
https://ramkedem.com/en/acdb-sample-database/

Written SQL tutorials including exercises -
http://ramkedem.com/en/sql-server/

About Myself -
https://ramkedem.com/en/about/

My Linkedin Page -
https://www.linkedin.com/in/ram-kedem-a5b4b33b/

My Facebook Page -
https://www.facebook.com/RamKedemFeed

SQL Platform Differences (comparing MySQL & Oracle) -

MySQL -
* Instead of LEN(), in MySQL we use the LENGTH() function -
https://www.w3schools.com/sql/func_mysql_length.asp

Oracle
* Instead of SUBSTRING, in Oracle we use the SUBSTR() function -https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions162.htm
* Instead of LEN(), in Oracle we use the LENGTH() function -
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions076.htm
* RIGHT() and LEFT() functions don't exist on Oracle, the Oracle equivalent would be
LEFT(FieldName, 10) = SUBSTR(FieldName, 1, 10)
RIGHT(FieldName, 3) = SUBSTR(FieldName, -3)