Append to column-string without reading it from Database

how is it poss开发者_如何学编程ible to append to a column (type string) without reading the whole value from the database.

Let's say the column, named "mycol" contains the string 'TESTtestTEST' and now I want to APPEND to this string the value 'abc', so 'TESTtestTESTabc' is stored in column mycol.

How can I do this?

Thank you very much for your help!

beside the fact you are using EF as DataLayer, wouldn't this task be done with an UPDATE statement? If so, you can execute the remote/store command on the datacontext to either call a stored procedure ( good ) or passing directly the SQL ( not so good ).

In MySQL I would do: UPDATE my_table SET mycol=CONCAT(mycol,'abc') WHERE ID=1;