You can use "+" operator to concatenate string but you'll have to add separator in between and handle NULL values yourself.

* mysql
CONCAT_WS(separator,str1,str2,str3)
* MS SQL
str1 + separator + str1 + separator + str3

>At MySQL I can use concat_ws for Concatenate With Separator .. what is similar function of concat_ws in SQL server? ..
>
>
>