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.

Example

select (Name + ' From ' + GroupName) as IDName FROM HumanResources.Department
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.

More Articles

 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.