When I run a query like this:
UPDATE MyTable SET MyFld ='Some Value' + MyFld WHERE ID = 100
It works on the SQL Server 2005, but not on 2000, where I get the following error:
Msg 403, Level 16, State 1, Line 1
Invalid operator for data type. Operator equals boolean AND, type equals text.
What is the correct method of connecting the string values together the SQL command ?