Concatenating Strings in MS SQL Server with CONCAT or the + Operator, and Its Equivalent in MySQL

In MS SQL Server, the CONCAT function was only introduced in the 2012 edition. In prior versions you have to use the + operator to join strings.

MS SQL Server

Syntax:

CONCAT ( string_value1, string_value2 [, string_valueN ] )

Example:

Select concat('This ','is ','Testing');
------------------------------
This is Testing

Using the + operator:

select 'This ' + 'is '+'Testing';
------------------------------
This is Testing

MSSQL + concatenate operator

MySQL

The equivalent function in MySQL is available with the exact same name: CONCAT. MySQL also provides an extended function called CONCAT_WS, which joins strings with a separator character.

Example:

Select concat('This ','is ','Testing');
------------------------------
This is Testing

MySQL Concat function

CONCAT_WS concatenates strings with a separator in between — the first argument is the separator for the rest of the arguments, added between each string.

Syntax:

CONCAT_WS(separator, str1, str2, ...)

Example:

mysql> select concat(' ','This','is','Testing');
---------------------
This is Testing

mysql> select CONCAT_WS(', ','Adam','Smith','Joseph');
--------------------------------------------
Adam, Smith, Joseph

MySQL CONCAT_WS Function

Back to Converting Functions from MSSQL to MySQL

The MSSQL to MySQL converter will automatically convert MSSQL functions to their equivalent in MySQL while converting views.