SQL Training Online

  • Training Courses
  • Beginner Book
  • Blog

February 14, 2015 by Joey Blue Leave a Comment

How to use the SQL Server String Concat Function in SQL Server 2012

 

SQL Server 2012 includes a new Concat function that makes it easier to put strings, numbers, dates, and nulls together.

The old way was with ‘+’ signs and cast or convert.  Now you just use the SQL Server String Concat Function.

In this video I do a quick demonstration of the Concat Function.

Video: SQL Server String Concat


How to use the new SQL Server 2012 CONCAT Function to combine columns and strings.

I use the Chinook Sample Database and the following scripts:

select FirstName + ' ' + LastName + '-' + Company 
from customer

select CONCAT(FirstName,' ',LastName,'-',Company)
from customer

 

See the original  SQL Concat Function video.

Filed Under: SQL Tip Tagged With: SQL Concat, SQL Convert, SQL Server 2012, SQL String Concat

Recent Posts

  • SQL Database Normalization – 1NF, 2NF, 3NF, and 4NF
  • SQL Joins Tutorial for Beginners – Inner Join, Left Join, Right Join, Full Outer Join – SQL Training Online
  • Zillow House Price Analysis from CSV Archive – #PowerBI 002
  • Learn Basic SQL – 1 Hour Training Course – SQL Training Online
  • Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset – SQL Training Online

Popular Posts

  • SQL Functions
  • SQL Jobs in Oracle and Microsoft SQL Server
  • Troubleshooting a SQL Join

Have Questions? Connect with me.

Link to my Facebook Page
Link to my Pinterest Page
Link to my Rss Page
Link to my Twitter Page
Link to my Youtube Page
Copyright © 2023 · SQLTrainingOnline.com · Consulting at EmbarkBlue.com