CONCAT_WS() Function in SQL Server
Last Updated :
02 Dec, 2020
CONCAT_WS() :
This function concatenates two or more strings together with a separator.
Syntax :
CONCAT_WS(separator, input_string1, input_string2, [...input_stringN]);
Parameter :
This method accepts two-parameters as mentioned above and described below as follows.
- separator –
It is an expression of any character type like char, nchar, nvarchar, or varchar.
- input_string –
It is an expression of any type. The input_strings to add together.
Returns :
It returns a concatenated string value.
Example-1 :
Use ‘ – ‘ to separate the concatenated string values.
SELECT CONCAT_WS(' - ', 'GeeksforGeeks', 'computer', 'science', 'portal');
Output :
GeeksforGeeks - computer - science - portal
Example-2 :
Use ‘ ‘ to separate the concatenated string values.
SELECT CONCAT_WS(' ', 'Hardik', 'Pandya') Your_Name;
Output :
Example-3 :
Using CONCAT_WS() with NULL values.
SELECT CONCAT_WS(', ','DN Block', 'Bidhannagar',
NULL, 'Kolkata', NULL, 700091)
AS Your_Address;
Output :
Your_Address |
DN Block, Bidhannagar, Kolkata, 700091 |
Example-4 :
Using CONCAT_WS() with table columns.
Table -Player_Details –
PLAYERID |
PLAYERNAME |
NICKNAME |
45 |
Rohit Sharma |
Hit Man |
18 |
Virat Kohli |
Chiku |
7 |
MS Dhoni |
MSD |
SELECT
PLAYERNAME,
NICKNAME,
CONCAT_WS(' - ', PLAYERNAME, NICKNAME) Name_with_NickName
FROM
Player_Details
Output :
PLAYERNAME |
NICKNAME |
Name_with_NickName |
Rohit Sharma |
Hit Man |
Rohit Sharma – Hit Man |
Virat Kohli |
Chiku |
Virat Kohli – Chiku |
MS Dhoni |
MSD |
MS Dhoni – MSD |
Share your thoughts in the comments
Please Login to comment...