update "vendors" set remit_address_1 = concat(left(remit_address_1, locate(char(13), remit_address_1) - 1),

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

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

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

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

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

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

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