It's generally a bad idea to store comma separated lists in SQL at all, yopu woudl probably be better off with a second table and a foreign key.
But...
UPDATE MyTable SET MyColumn = MyColumn + ',' + 'My new item' WHERE MyIDColumn=MyIDValue
Takign one back out again is a much, much harder process - which is one of the reasons why the second table is a much better design.