COUNT() Function in SQL Server

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 :

Your_Name
Hardik Pandya

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

COUNT() Function in SQL Server

sanjoy_62

Improve

Article Tags :

Similar Reads

COUNT() Function in SQL Server

The COUNT() function in SQL Server is a fundamental aggregate function used to determine the number of rows that match a specific condition. Counting rows provides valuable insights into data sets such as the total number of records, distinct values, or records meeting certain criteria.In this artic

CONCAT_WS() Function in MySQL

CONCAT_WS() : This function in MySQL helps in joining two or more strings along with a separator. The separator must be specified by the user and it can also be a string. If the separator is NULL, then the result will also be NULL. Syntax : CONCAT_WS(separator, string1, string2, ...) Parameters : se

ATN2() Function in SQL Server

In this article, we are going to cover the ATN2()function in which we will see how we can get the arc tangent of two given numbers. Let's discuss one by one. // here val1 and val2 are input. Input : ATN2(val1, val2) Output : Arc tangent result. ATN2() : It is the function that returns the arc tangen

SUM() Function in SQL Server

The SUM() function in SQL Server is an essential aggregate function used to calculate the total sum of values in a numeric column. It aggregates data by summing up all values in the specified column for the rows that match the criteria of the query.In this article, We will learn about SUM() Function

STR() Function in SQL Server

The STR() function converts a numeric value to a character value. Syntax : STR(float_expression [, length [, decimal]]) Parameter : This method accepts three parameters as mentioned above and described below : float_expression : It is a numeric expression that evaluates to an approximate number with

DAY() Function in SQL Server

DAY() function : This function in SQL Server is used to return the day of the month i.e, from 1st to 31st for date stated. Features : This function is used to find the day of the month for a date specified. This function comes under Date Functions. This function accepts only one parameter i.e, date.

TAN() and COT() Function in SQL Server

1. TAN() Function : The TAN() function returns the tangent of a number. Syntax : TAN(number) Parameter : Required. A numeric value. number : It is a numeric value. Returns : It returns the float_expression of the tangent of a number. Example-1 : When the arguments holds a positive number. SELECT TAN

SQRT() Function in SQL Server

SQRT() function : This function in SQL Server is used to return the square root of a specified positive number. For example, if the specified number is 81, this function will return 9. Features : This function is used to find the square root of a given number. This function accepts only positive num

DATEADD() Function in SQL Server

DATEADD() function : This function in SQL Server is used to sum up a time or a date interval to a specified date, then returns the modified date. Features : This function is used to sum up a time or a date interval to a date specified. This function comes under Date Functions. This function accepts

ASCII() Function in SQL Server

The ASCII() function returns the ASCII value of the leftmost character of a character expression. Syntax : ASCII(character_expression) Parameter : This method accepts a single-parameter as mentioned above and described below : character_expression : It can be a literal character, an expression of a