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

hello guys welcome to my channel this is
the 38 tutorial in this course and in
this tutorial we are going to begin our
discussion on string functions and the
first one that we're going to check out
is the concatenate and it's used to
concatenate strings right so a string
firstly you know that is a collection of
characters that you enclose within
single quotes right so that's what a
string is in SQL and if suppose you have
a few strings and you want to put them
together and make one string out of them
then you use the concat function for
that the way you use it is let me get my
cursor in here type in select first and
then the name of the function which is
concatenate all your string arguments
separated by a comma and you know you
obviously have to enclose your strings
within single quotes right so if you
want to you know just test the
traditional example which is to display
hello world on screen you know you put
in hello first and then put a comma and
then within single quotes you put in
world and I also put an exclamation
character at the end I put a semicolon
at the end and there you go when I
execute the query I see in the result
side hello world right so it's pretty
simple if you have more than two strings
and you know you just have to use more
comma symbols to separate the string
arguments right so if suppose you had
another one here then you could put a
comma and then put in a third string
argument within single quotes right now
with this function you can also you know
pull in stuff from tables that you have
in your database right so for instance
we worked with the tutorial table and in
the tutorial table we had the field name
title and we also had a field name the
subject right so title was basically the
name of the tutorial and subject was the
name of the subject to which the Detroit
belong to right so if suppose you wanted
to see you know
the tutorial name and then the string
belongs to and then the name of the
subject right so if you wanted to see
something like that for all the
tutorials in the table then you could
use the concat function and the way you
would do that is let me close this
result set first and we'll type in
select and then concat which is the name
of the function that we are going to use
and then I'll type in title here which
is the name of the field from the
tutorial table I'll put a comma and then
within single quotes I'll put a space
first because I would want to see some
space between the name of the tutorial
and the string belongs to later I'll
type in belongs to here I'll put a space
after two as well and then I'll put
another comma and I'll put subject here
because this is the name of the subject
field from the tutorial table and when
we display this as a you know tutorial
right now the next line I will type in
from and the name of the table which in
this case is tutorial and I will put in
a semicolon at the end and when I press
control enter I see that I get you know
a result set with all the rows from the
tutorial table so select querido it
belongs to SQL insert query belongs to
SQL arithmetic operators belongs to SQL
and then functions belongs to see
structures belongs to C so you know
basically it's done this the
concatenation operation for all the rows
in the table right so that's it about
the concat function it's very useful and
you know whenever you want to take in
first names and last names from your
users through a website and you want to
display the names together as one string
then you know basically you would have
to use the concat function either in the
backend you know with your database or
you know through your scripting language
you know if you were scripting through
PHP then you know you have can carry
equivalent PHP too and that's pretty
much about it in the next video we will
check out another string function and
thank you so much for watching this one
and you may subscribe to my channel if
you haven't already and I'll see you
soon