>select * from mymain where my_id = '01047' >set concat_null_yields_null off >update mymain set notes = cast(notes as varchar) + 'and Test...' WHERE my_id = '01047' >select * from mymain where my_id = '01047' >set concat_null_yields_null on >>
create TABLE #table (notes varchar(10),notes2 varchar(10)) GO INSERT INTO #table VALUES (REPLICATE('B',10),NULL) GO UPDATE #table SET notes2 = notes + 'A' -- warning GO UPDATE #table SET notes2 = CAST(notes AS VARCHAR) + 'A' -- warning too !!! GO DROP TABLE #table goYou have to uses ISNULL() with attention because for me exists a bug and it can return not expected datatype.
update tbl_main set name = COALESCE(name,'') +' MORE STUFF TO ADD TO NAME FIELD' where my_id = '01-011'