Update Concat statement SQL Server 2008

Asked May 24 '17 at 13:14

Active May 24 '17 at 13:16

Viewed 48 times

I'm trying to do an update to a column by concatenating some new data into the field.

UPDATE [dbo].[EmailReporting]
SET [EmailTo] = CONCAT(EmailTo, '; Reporting@xyz.com')
WHERE ReportTypeId in (3, 4, 5, 6)

This particular database is 2008 and I guess concat only works in 2012 because I'm getting an error that it is not a recognized function name. What would be the equivalent for 2008?

edited May 24 '17 at 13:16

Arulkumar

12,966
14
47
68

asked May 24 '17 at 13:14

Rick Kountz

2

u can use `+` operator – Hexxx May 24 '17 at 13:15
2

`SET [EmailTo] += ';Reporting@xyz.com'` but it would likely be better to have a design where each address lives on its own row. – Alex K. May 24 '17 at 13:16
https://learn.microsoft.com/en-us/sql/t-sql/language-elements/string-concatenation-transact-sql – NiH May 24 '17 at 13:17
Thanks that's what I needed! – Rick Kountz May 24 '17 at 13:50

Update Concat statement SQL Server 2008

0 Answers0