Ben Ben - 2 years ago 235
SQL Question

Concatenation in SQL Server Management Studio 2014

I'm trying to use the concat function in SQL Server 2014. It keeps giving me this error though and I'm curious why and how to get around it? MY code is below. Thank you!

Msg 195, Level 15, State 10, Line 17 'concat' is not a recognized
built-in function name.

Select concat([Column 2], [Column 3])
FROM [eCommerce1].[dbo].[All march june Data]

Answer Source

As discussed in the comments above, you can't use features in a newer version of SQL Server on older versions of the product, regardless of what SSMS version you are using. In the case of concatenation, this should do just as well in your case, using older syntax from SQL Server 2000 (

SELECT [Column 2] + [Column 3]
FROM [eCommerce1].[dbo].[All march june Data]
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download