select REPLACE (other3,'?',''), * from rp_t_accout_payrec_flow where charindex('?',other3)>0 update rp_t_accout_payrec_flow set other3=REPLACE (other3,'?','') where charindex('?',other3)>0