SQL String concatenation operators

OBJECTIVE

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

 

Output

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.

 

SUMMARY

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 *