How to concatenate two strings in SQL?

Question

Can anyone tell me how to concatenate two strings in SQL?

Answer 1

We can use CONCAT() function to concatenate two or more strings in SQL. Here is the syntax to use CONCAT() function for combing two or more strings:

CONCAT( String_1, String_2, String_3,……)

Here is an example to concatenate two strings in SQL:

SELECT CONCAT ( ‘SQL’, ‘Tutorial);

To learn string functions in SQL, you should sign up for this SQL training course by Intellipaat.