使用T-SQL / MS-SQL将字符串附加到现有表单元的最简单方法是什么?

I have a table with a 'filename' column. I recently performed an insert into this column but in my haste forgot to append the file extension to all the filenames entered. Fortunately they are all '.jpg' images.I have a table with a 'filename' column. I rece