vendredi 6 mai 2016

How to update data in a field


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.


Aucun commentaire:

Enregistrer un commentaire