SQL Tutorial - 41: SUBSTR(); RIGHT() & LEFT() Functions Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 41st you told in this course and in
this tutorial we are going to talk about
three more string functions the first
one is the substring or the SUV STR
function and then we are going to talk
about the right and left functions which
are you know just simple variations of
the substring function and the substring
function as the name suggests is used to
get you know a part of the string right
so if you've got a long string and if
you just want to display a part of it on
the screen to the user then you could
use the substring function to get that
part right so I'll just demonstrate the
function to you so I'll type in select
first and then the name of the function
which is sub STR right so sub and then
STR is a short form for string and then
within parentheses you'll have to type
in your string first it takes in three
arguments the substring function the
first one is the string and the second
argument is the offset position and the
third argument is the number of
characters that you want starting from
your offset position right so if suppose
I have a string like I need a break
right if this is my string and if I want
to get the word need out of the string
then I'll have to determine my offset
position first and the offset position
is basically the position of the
characters from where you want to start
chopping off the string right so I is
the first character right and then
you've got a space after I so the space
character is the second character and
then n is the third character right so
if you want the word need in your offset
position for for the word need is going
to be three so you type in that and then
you put in a comma and the third
argument as I said is the number of
characters that you want beginning from
your offset position so in this case
since I what need the word need you know
need has got four alphabets so I'll type
in four here as a third argument right
so I'll put a semicolon when I execute
this I just see the word need I don't
see the rest of the words in the string
right and similarly if you need the word
break let's say then you have to first
determine what's the position of the
alphabet B in the string so eyes first
then the space here is second n is
three and then e 4 E 5 D 6 7 8 9 and
then B is 10 right so I'll have to get
10 here as the offset position and since
the word break has 5 characters I'll
have to put in 5 here instead of 4 when
I would execute the string the square e
I would get break as the result right so
this is the substring function and it's
very useful and very popular and you
would use it a lot trust me on that and
you know if you want to get portions
from your strings that are you know at
the ends right so in this case break is
the last word in the string so if you
just needed break and you didn't want to
use a substring function because
substring function can be you know
tricky to use because you know you have
to determine the offset position in this
case a string was small so we you know
easily conveniently found out the
position of the alphabet B in the string
but otherwise you would have to first
use a length function and then count the
number of characters from the end and
you know it gets complicated to count
you know or estimate the offset position
in long strings right so if you know
that you have to get portions from the
end like in this case we know that break
is the rightmost word in the string so
we could use the right function instead
right so with the right function you
don't have to use you don't have to
supply the offset position as an
argument you could just you know mention
right since it is a function you know it
the function takes in portions from
strings that you know are at the
rightmost so in this case break is the
rightmost word and five characters would
be taken from you know beginning from
the right so K a e-r and B these are the
five rightmost characters and they would
be chopped off and displayed so I would
execute the query this is what I would
get and you know you also have the left
function you know to get in the leftmost
portion from the string so you type in
left and let's say you need a you know I
need you need that phrase so I n space
two characters and the need is four so
you type in six here so you would get
the phrase I need there right so that's
what about the substring right and left
functions and thank you so much for
watching this too
in the next tutorial we will discuss a
few more string functions and you may
subscribe to my channel if you haven't
already and take care