:::: MENU ::::

T-SQL String concatenation

  • Apr 30 / 2010
  • 0
dbDigger, String Manipulations, T-SQL Interview Questions, T-SQL Tips and Tricks

T-SQL String concatenation

If you are going to google the terms like ‘T-SQL concatenate’ to view the syntax of assumed concatenate or concate built-in function, then there is no need to do it. T-SQL allows you to concatenate two or more strings by just using + sign among strings.
To experience, use following code line in SSMS

print 'string1 '+'concatenated to '+'string2'

It would provide following result

SSMS result for concat sign

Consult us to explore the Databases. Contact us