I have a table where the key field is index a candidate index and field a want change is a regular index. I get the message

Failed to update table,  Unique index violation

The error number is 1884. How do I change the second value, i,e, from a "B" to an"A"?