I have a field in a table that contains a large number of CSVs.
I need the SQL to swap all the elements in the string with their equivalent sourced from another table - see attachmnent example.
any help gratefull received..
old string = a,b,c,d
new string = 1,2,3,4