MSSQL function to concat any number of strings

Databases
1

Is there any way to implement a function in MSSQL server to pass any number of strings as input and concatenate them?
For example, in mysql, it can be done with

CONCAT(col_a, col_b, col_c) FROM table;
  • won’t solve my case here, because it needs definite number of parameters.
2

use +

by the way, you can’t do it in mysql either, because it needs definite number of commas :slight_smile:

3

You really want to do that on the client app side.