什么数据库?SqlServer?
试试
cmd.CommandText = "UPDATE 开piao流水 SET piao据编号集合 = replace(piao据编号集合,','+?+',',','+?+',') WHERE piao据编号集合 like '%,'+?+',%'"cmd.Para meters.Add("@编号1",hm_n)
cmd.Para meters.Add("@编号2, hm_o )
cmd.Para meters.Add("@编号3, hm_o )
如果不行就只能直接拼sql
cmd.CommandText = "UPDATE 开piao流水 SET piao据编号集合 = replace(piao据编号集合,','+" & hm_n & "+',',','+" & hm_o & "+',') WHERE piao据编号集合 like '%,'+" & hm_o & "+',%'"