update 表名
set 列名
=
stuff(列名,起始位,字符数,替换后的值)
update CZL_CompanyInfo set companypic = stuff(companypic, 13, 1, '')
update CZL_CompanyInfo set companypic = stuff(companypic, 13, 1, '')
转载于:https://www.cnblogs.com/yinpeng186/archive/2011/10/25/2223537.html