Search code examples
sqlsql-serverstring-concatenation

Concatentation in SQL

Is there any way to concatenate two strings without using '+' operator or CONCATENATION function?

Solution

  • You can use stuff() function - reference 

    SELECT STUFF('One match', 5, 0, 'day ')