Loading lesson path
Concept visual
Start at both ends
Add strings together. Use '.' to separate the concatenated string values:
CONCAT_WS('.', 'www', 'W3Schools', 'com');The CONCAT_WS() function adds two or more strings together with a separator.
and
Formula
Concat with the + operator.CONCAT_WS( separator, string1, string2,...., string_n )
Required. The separator to use string1, string2, string_n Required. The strings to add together
SQL Server (starting with 2017), Azure SQL Database, Azure SQL Data
Add strings together. Use '-' to separate the concatenated string values:
CONCAT_WS('-', 'SQL', ' is', ' fun!');❮ SQL Server Functions