I have one column of data, "Name_Position" with a name+delimiter+position As in, "Terry~Fielder" and "Brian~Pitcher" in order to match other table column delimiters, I need to change the "~" in the middle to "~/~"
UPDATE tblPayers SET Name_Position = ???~ || '/~' || ???
Could someone please help me out as there are many hundreds of rows. I have searched around and not found anything to help. There are no other columns in this table with the singular data to use a straight concatenation.