UPDATE Table_Name SET Column_Name = REPLACE(Column_Name, '123', '')
Thanks Pavan Kumar Mark Answer if this fits the need
update TableName set ColumnName=Replace(ColumnName,'123','')
Login to post response