SQL String concatenation operators


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.



string concatination operator example

Example Description
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.

Leave a Reply

Your email address will not be published. Required fields are marked *