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: 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: youtube.com/watch?v=nbIicI7K6Kk

Support the Channel:
1) Subscribe: becomingads.com/o/youtube
2) DataCamp: becomingads.com/o/datacamp
3) Udacity: becomingads.com/o/udacity