select col+(case when right(col,1)='a' then 'b' else '' end) as col from tb
select replace(字段,'a','ab')from 表要这样？
