I have few junk records in a DB2 table.
one field, Emp No has 14 characters size.
This field has few records(almost 100 records) in that table which are junk records. The junk records are like: MSKU1851295ááá, MRKU7998390 á.
So I want to remove these junk characters from these records.
I can able to fetch these records thru a SQL query. But my intention is to remove these junk characters from these records. After changes, these above records should be: MSKU1851295, MRKU7998390.
How to do this in a better way?
Thanks in advance