0 votes
1 view
in SQL by (55.4k points)

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

1 Answer

0 votes
by (119k points)

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.

Welcome to Intellipaat Community. Get your technical queries answered by top developers !