How to append string in SQL query?

Question

Can anyone tell me how to append string in SQL query?

Answer 1

In SQL, we can use CONCAT () function to append a string to another string. The following is the syntax to use CONCAT() function:

CONCAT (String_1, String_2, String_3,…….)

Here are the few examples to append strings in SQL:

SELECT CONCAT (‘SQL’, ‘ is’, ‘ easy’);

SELECT CONCAT (‘SQL’, ‘ is’, ‘ very’, ‘ easy’);

After running the queries, the result would be as follows:

SQL is easy

SQL is very easy

You can check out this SQL Tutorial blog to learn string functions.