[sql-server] Simplest way to append data to a SQL Column

I'm sure i can figure something out using replace, etc, but just wondering if there is anything out there that lets you simply append data to a column rather than how the common Insert function works?

Well I guess i can do INSERT INTO TABLE (NAME) SELECT Name + @Name right?