SQL Tutorial - 40: The TRIM() Function Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
a 40th tutorial in this course and in
this tutorial we are going to talk about
the trim function and SQL the trim
function is used to remove leading and
trailing spaces from strings right so I
hope you guys know what leading and
trailing spaces are basically space that
you have on either side of your string
before the first character of the string
and after the last character of the
string you know that kind of spaces in
most cases unwanted right so if you want
to remove them from your strings before
displaying your strings on screen then
you use a trim function right so let me
first show you guys a string that's got
you know leading and trailing spaces so
I'll just type and select in single
quotes I'll have a string something like
I have got too much space on either side
and you know press the spacebar key for
a couple of seconds so there you go you
see that you've got some space here
right all these space characters and
you've got some space here too right now
if you are using MySQL at the back end
you're doing scripting in PHP or some
other language and you're displaying you
know strings you know on browsers then
you know browsers by themselves they
eliminate you know leading and trailing
white spaces right but you still cannot
rely on that and you know if you're
doing some kind of software development
and you're displaying the you know
essential information or messages on
screen or you know some details then you
would want to eliminate these you know
unnecessary space characters before
showing the strings on-screen so let me
just show you guys how this string looks
like so there you go you see that you
know you get some extra space on both
sides right there's space here on this
side and this space on this side too
although you cannot make out that
there's any space here but you know
there is trust me about that so if I
would use the trim function on the
string I will have to type in trim and
then I have to enclose the string within
a set of parentheses and that's what we
do with all functions right so when I
would press control enter now you would
see that there is no space on either
side although again you cannot make out
whether there is any space after the
word side in this string or not but
trust me there isn't and
you can be like absolutely sure that the
space that was there before the first
alphabet I has you know that has
definitely been removed right so that's
it about the trim function I see you
guys in next tutorial in which we
discuss you know more string functions
and thank you so much for watching this
one and you may subscribe to my channel
if you haven't already in a season