Does anyone know how I would go about concatenating a string in SQL Server 2005.
What I mean is something like the following scenario.
I have a nvarchar(MAX) column in a SQL Server 2005 database.
Lets say the column has a value of "A" and I want to add "B" making "AB", what is the simplest way to go about this. Will I need to do a Select, concatenate the two values in code and then update the column? Or is there a more nifty way to do this?
Any pointers much appreciated.
FlySwat :
In T-SQL:\n\n UPDATE table SET col = col + 'B' WHERE (PREDICATE THAT IDENTIFIES ROW)\n\n\nIf you were using Oracle it would be:\n\n UPDATE table SET col = col || 'B' WHERE (PREDICATE THAT IDENTIFIES ROW)\n",
2009-12-04T05:54:57