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!

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

Support the Channel:

[jehushaphat]

Of all the SQL videos out there, yours have been the most helpful to me!

[ianpropst-campbell]

Great video! Really appreciated seeing the example of using the combination of left, right, char_length and position to separate first and last name

[tonyperez]

Great job. Your videos are really helping me to understand SQL. THank you for your time!!!

[SjeetjeMineetje]

Thank you, watched a few of your SQL videos now and they're all really well explained!!

[michaeljones]

Thanks, these videos are short and to the point, and so very helpful!

[itsReshad]

Great video and explanation! Thank you so much - keep the good content coming my friend!

[liyuanfeng]

really awesome videos during my learning journey, so helpful!

[lekhnathsharma]

Your way of teaching is pretty cool. Love it :)

[definitelynotmpc]

Yo, where did the SQL joins tutorial go? I clicked on this video (seeing "LEFT") and though it was the joins one but I can't find it anywhere

[jananiarunachalam]

Thank you for these great tutorials! Can't stress how much I appreciate these.

[rayyuda]

Explain lag and lead function please! Thanks in advance

[deyscube]

I want to see all the data when you replaced then what will be the syntex

[rajupaudel]

Hey Sir, what about the those who has the middle name and if we want to separate middle name as well ?? Could you please make a video on that as well. Thank you!!

[thegymteachersgrandma]

Nice, just got in and it says sql error.... lovin it

[GregMoranCom]

Awesome Videos: I am new and came across this: Any wisdom on how to display? Thx

[musondaben]

How can you find the position of a space in a name

[higiniofuentes]

You are using Postgres, but if you use another db, these functions are spelled the same?