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

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

1 Answer

0 votes
by (87.5k 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.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...