SQL Unable to Concatenate

Question

I am using SQL Server 2008 R2 and am trying to run the following command:

SELECT CustCity AS City, Concat(CustLastName, \', \', CustFirstName) AS Customer
FROM Customers
ORDER BY CustCity, Customer

The error message I am receiving is:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ', \'.

As far as I have learnt, this is how Concat should work so I don't understand why this is not working.

Can anyone help?

Answer 1

You can try like this:-

SELECT CustCity AS City, CustLastName + '\' + CustFirstName AS Customer
FROM Customers
ORDER BY CustCity, Customer

CONCAT function doesnot exist in SQL SERVER 2008.

Answer 2

Do this instead:

SELECT CustCity AS City, CustLastName + '\' + CustFirstName AS Customer
FROM Customers
ORDER BY CustCity, Customer

Answer 3

CONCAT() is not a function of SQL Server 2008. If you want to concatenate the data in sql server, you should use the + sign:

SELECT CustCity AS City, CustLastName + ', ' + CustFirstName AS Customer
FROM Customers
ORDER BY CustCity, Customer;

See SQL Fiddle with Demo. If you want to include the \, then you can use:

SELECT CustCity AS City, CustLastName + ' \ ' + CustFirstName AS Customer
FROM Customers
ORDER BY CustCity, Customer

See Demo

Answer 4

Fairly certain your single quote ' is causing the problem. Problem is CONCAT only exists in SQL 2012 not 2008.

If you were using SQL 2012, the proper syntax would be.

Concat(CustLastName, '\', CustFirstName) AS Customer