Query for switch empty location code to specific location code

Update stk_grndo_dt SET LocationCode = 'xxx' Where LocationCode = '';

Update stk_sup_inv_dt SET LocationCode = 'xxx' Where LocationCode = '';

Update stk_do_dt SET LocationCode = 'xxx' Where LocationCode = '';

Update stk_cus_inv_dt SET LocationCode = 'xxx' Where LocationCode = '';

Update stk_inventory_dt SET LocationCode = 'xxx' Where LocationCode = '';

Update stk_inventory2_dt SET LocationCode = 'xxx' Where LocationCode = '';

Update stk_detail_trn_in SET LocationCode = 'xxx' Where LocationCode = '';

Update stk_detail_trn_out SET LocationCode = 'xxx' Where LocationCode = '';