2 Replies Latest reply: Jul 6, 2011 11:20 AM by Jason Michaelides RSS

    Replace substring in all fields

    Jason Michaelides

      Hi all,

       

      I have a data set that has been screwed up with incorrect encoding before it got to me.  The result is that all fields (there are 70+ of them!) have some incorrect characters - e.g. & instead of &

       

      Instead of using REPLACE(fieldname,'&','&') on every field, is there a way of globally replacing these?

       

      Cheers,

       

      Jason