Multiple choice

In SQL server, which of the following operators is/are used to combine two strings in the results?

  1. CONCAT(), AND

  2. CONCAT(), +

  3. CONCAT(), ||

  4. CONCAT()

  5. CONCAT(), -

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In SQL server, CONCAT(), + are used to concatenate two strings in the results. Example: SELECT Region_Name + ' ' + Store_Name FROM Geography WHERE Store_Name = 'Boston'; Output: 'East Boston'