求3条SQL语句（急需）谢谢大家的阅览

Question

1.
update QQ
set QQmc=replace(QQmc,'甲','')2.delete t
from QQ t
where right(QQmc,1)='甲'
      and 
      exists(select 1 
                from QQ 
                    where t.QQmc like '%'+QQmc+'%' 
                          and QQbh<>t.QQbh)3.select * from QQ t
where exists(select 1 
                from QQ 
                    where (t.QQmc like '%'+QQmc+'%' 
                          or QQmc like '%'+t.QQmc+'%')
                          and QQlb<>t.QQlb)
order by left(QQmc,2),QQbh

Answer 1

谢谢 如果只想删除末尾含有的'甲' 比如 字段QQMC中数据  甲汽车 甲   只删除末尾甲 怎末写SQL语句呢

Answer 2

只想删除末尾含有的'甲' 
update QQ
set QQmc=left(QQmc, len(QQmc) - 1)
where QQmc like '%甲'