SQL String Functions Tutorial (LEFT, RIGHT, POSITION, CONCAT, LOWER, REPLACE)

A step-by-step video tutorial on the most popular SQL string functions like CHAR_LENGTH, LEFT/RIGHT, CONCAT, POSITION, UPPER/LOWER, and REPLACE! List of string functions: Queries: 1) Get the number of characters in a string: SELECT CHAR_LENGTH(column1) FROM table 2) Get a certain number of characters starting from the left: SELECT LEFT(column1, 5) FROM table 3) Get a certain number of characters starting from the right: SELECT RIGHT(column1, 5) FROM table 4) Get the position of a character in a string: SELECT POSITION(' ' IN column1) FROM table 5) Combine strings together: SELECT CONCAT(column1,' ',column2) FROM table 6) Make all the characters in a string lowercase: SELECT LOWER(column1) FROM table 7) Make all characters in a string uppercase: SELECT UPPER(column1) FROM table 8) Replace characters in a string: SELECT REPLACE(column1,' ','') FROM table Get the Northwind Database:    • How to Load a Sample PostgreSQL Database i...   Support the Channel: 1) Subscribe: 2) DataCamp: 3) Udacity: