Compare Two Columns, Remove Duplicate Characters
Assuming that you mean to remove the character of CA from CB in the same row and that there's always just one character in CA, you can do it like this:

UPDATE your_table
SET CB = REPLACE(CB, CA, '');