I need to modify all characters within a text field. Some of the fields will contain 2-5 characters, others will contain 20-200 or more. The field is defined as Text 4000. I want to replace every letter with "K"
We have a Select statement: select TRANSLATE(UPPER(field_name),'ABCDEFGHIJKLMNOPQRSTUVWXYZ','XXXXXXXXXXXXXXXXXXXXXXXXXX') field_name from my_table
But need to have an UPDATE to replace all the text so that the field is completely unreadable since it could contain private information and we need to use it for testing.