MSSQLString FunctionsCONCAT_WS
CONCAT

CONCAT_WSString Functions

SUBSTRING

Concatenates strings with a separator between each.

Syntax

CONCAT_WS(sep, str, ...)

Example

Enter values below to update the example in real time.

department
job_title
employees
SELECT CONCAT_WS(' / ', department, job_title) AS position
FROM employees;