Change Data Type

Question

I made a mistake years ago, that just came up. 
 We use two fields, the competitor an Account uses, and then what competitive software we converted them from. 
 It seems I created one as a DropDown instead of a MultiSelect, as it should have been. 
 We have tons of data in the Converted From now. 
 Is there any way to convert this to a MultiSelect now, without losing all the data in that field across Accounts?

John Kitsmiller · Answer

Yes, it is possible, send to Sugar Support 2 queries: 
 
 Query to update the respective fields_meta_data from enum to multienum 
 Query to massp update all existing data, like UPDATE table SET field = CONCAT("^", field, "^")

Query 2 must be executed after confirming that the target field has been converted properly. It requires QRR after running query 1, I would do that twice to make sure!