update "customer" set main_address_1 = concat(left(main_address_1, locate(char(13), main_address_1) - 1),

substring(main_address_1, locate(char(13), main_address_1) + 1)),

bill_address_1 = concat(left(bill_address_1, locate(char(13), bill_address_1) - 1),

substring(bill_address_1, locate(char(13), bill_address_1) + 1)),

ship_address_1 = concat(left(ship_address_1, locate(char(13), ship_address_1) - 1),

substring(ship_address_1, locate(char(13), ship_address_1) + 1)),

pp_address_1 = concat(left(pp_address_1, locate(char(13), pp_address_1) - 1),

substring(pp_address_1, locate(char(13), pp_address_1) + 1)),

pm_address_1 = concat(left(pm_address_1, locate(char(13), pm_address_1) - 1),

substring(pm_address_1, locate(char(13), pm_address_1) + 1));