SQL Tutorial - 43: REPEAT() & REPLACE() Functions Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 43rd tutorial in this course and in
this tutorial we're going to talk about
two more string functions the first one
that we're going to check out is the
repeat function and as the name suggests
the repeat function is used to repeat a
string a given number of times right so
it's syntax is pretty simple as a short
too you type and select and then the
name of the function which is repeat
right our EP e8e and then within
parenthesis the first argument has to be
the string that you want to repeat so
I'll just repeat the string good morning
right and let's say I want to repeat it
ten times so I'll type in 10 as the
second argument put in a semicolon at
the end and when I execute the query you
see that in the result set
the string good morning is repeated 10
times right and it's a very convenient
function to use and the next one that
we're going to check out is the replace
function and the replace function more
or less works like the insert function
but you know with the insert function
you know the job of the insert function
is to insert a string into another
string right but the job of the replace
function is to you know just replace a
part of a string or an entire string in
part with something else right so it's
more convenient you know if you're
thinking about replacing a part or all
of the string with another string then
you know you should use or use the
replace function instead of using the
insert function you know it's it's a
better alternative so I'll type in
replace and let's say from this string I
want to replace the word morning with
the word night right so the function by
the way takes three arguments the first
is your original string the second
argument is what you want to replace and
the third argument is what you want to
replace with right so the second
argument in this case will be morning
because that's what I want to replace
from the original string and the third
argument will be night because I want to
replace morning with night when I
execute this query I see the message
good night instead of good morning on
screen right so that's it about the
Rapide and replaced functions and I'm
going to see you in the next one which
will probably drop up our discussion on
string functions and discuss you know
all
the remaining string functions that I
wanted to discuss in the first place in
this course and thank you so much for
watching this video I see you in the
next tutorial and you may subscribe to
my channel if you haven't already and
take care