In this chapter you will learn:
What is String concatenation operator?
Types of String concatenation operators
Example of String concatenation operators
What is String concatenation operators?
That operator which is used to concatenate strings, columns and combination of columns and string into one expression or statement is called string concatenation operator.
The “+” operator is used to concatenate the strings, columns, etc.
select (Name + ' From ' + GroupName) as IDName FROM HumanResources.Department
In the above example From is a string that is used in between the Name and GroupName column records. The + symbon is used to concatinate the columns with from keyword.
In this chapter we have learned about String concatenation operators. In the next chapter you will learn about unary operater and its type.