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: https://www.becomingads.com/o/sql_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: https://www.youtube.com/watch?v=nbIicI7K6Kk Support the Channel: 1) Subscribe: https://www.becomingads.com/o/youtube 2) DataCamp: https://www.becomingads.com/o/datacamp 3) Udacity: https://www.becomingads.com/o/udacity