Concatenate SQL Records with UPDATE
Posted on 2007-12-03
Hello, I'm using SQL Server 2005 and I want to update the name in over 18000 records
I want it to be: name (size) instead of name:
Vitamin A (60 Caps)
right now its:
Set b.Name = b.Name' ('a.Size)'
From Product b, newproducturlinfo a
WHERE b.SKU LIKE a.UPC AND b.ProductID = 32167
I keep getting this:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ' ('.
I'm using ProductID = 32167 because I don't want to affect more then 1 record if it goes wrong. Any info will help. Thanks