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 P...
Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity:

[@jehushaphat]

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

[@ianpropst-campbell6028]

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

[@jananiarunachalam6678]

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

[@shepherdangel3370]

i realize it's pretty randomly asking but do anybody know a good site to stream new tv shows online?

[@bradenjefferson8342]

@Shepherd Angel Flixportal =)

[@shepherdangel3370]

@Braden Jefferson thanks, I signed up and it seems to work :D I appreciate it!!

[@definitelynotmpc4147]

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

[@definitelynotmpc4147]

Which was a great video btw, really carrying my IT mark

[@tonyperez2205]

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

[@michaeljones2843]

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

[@lekhnathsharma9002]

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

[@Victoria-dh9jp]

It was really helpful. God bless you

[@jettecantoria]

Thank you. You are awesome!

[@markwade4048]

Very helpful, great video

[@SjeetjeMineetje]

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

[@itsReshad]

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

[@higiniofuentes2551]

Thank you for this very useful video!

[@deyscube577]

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

[@nohbu9838]

This was great, clear and concise

[@factorise001]

really appreciate the knowledge

[@liyuanfeng497]

really awesome videos during my learning journey, so helpful!

[@rajupaudel1660]

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!!

[@RIVEXNGLE]

Likewise, companies that tack the suffix onto the last name.

[@stri06]

@@RIVEXNGLE use MID & POSITION

[@nikunjgupta7277]

Really helpful, thanks a lot!

[@estebandiaz1306]

Great video!

[@rayyuda4358]

Explain lag and lead function please! Thanks in advance

[@Nyansabln]

Thank you !

[@juliakristavilladiego4425]

Thank you. Really helpful! :)

[@김도형-g2i]

this is so good!!!

[@adiflorense1477]

very help!

[@thegymteachersgrandma]

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

[@ganeshch8840]

thanks mate.

[@GregMoranCom]

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

[@GregMoranCom]

it is in a cell labeled info

[@juliawoodcock5782]

Very helpful, thanl you

[@higiniofuentes2551]

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

[@musondaben7052]

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