Using CONCAT

- [Instructor] String concatenation allows us to chain…multiple strings together, that is, combine the values…of multiple varchar data types or string…retrieved by a SQL query into one longer string value.…Let's see an example.…We'll start by selecting the first name…and last name values from our employees table.…We can concatenate or combine the values of first name…and last name so that instead of the SQL query…returning name in two distinctly different columns,…which is how the data is stored in the table,…the SQL query can return them as one concatenated string.…

We simply do that by adding concat,…which is the name of the function,…and then inside brackets, specify the two column values…we want to combine together or concatenate together.…Running this query, we see that we got…a combined output of both columns.…We can also use concat and combine a literal string…with the value retrieved from a database column.…So for example,…I can type the concat function name, bracket,…and then First Name, comma,…and the first name column, comma, concat.…