Cash Sale Accountxx'Cash Sale Account'
update 101_client set comp_name = 'Cash Sale Account' where uid_client = 1
New World Albanyxx'New World Albany'
update 101_client set comp_name = 'New World Albany' where uid_client = 2
Pak'nsave Albanyxx'Pak\'nsave Albany'
update 101_client set comp_name = 'Pak\'nsave Albany' where uid_client = 3
New World Birkenheadxx'New World Birkenhead'
update 101_client set comp_name = 'New World Birkenhead' where uid_client = 4
New World Botanyxx'New World Botany'
update 101_client set comp_name = 'New World Botany' where uid_client = 5
Pak'nsave Botanyxx'Pak\'nsave Botany'
update 101_client set comp_name = 'Pak\'nsave Botany' where uid_client = 6
New World Brookfieldxx'New World Brookfield'
update 101_client set comp_name = 'New World Brookfield' where uid_client = 7
New World Browns Bayxx'New World Browns Bay'
update 101_client set comp_name = 'New World Browns Bay' where uid_client = 8
Campus & Co Cambridgexx'Campus & Co Cambridge'
update 101_client set comp_name = 'Campus & Co Cambridge' where uid_client = 9
New World Cambridgexx'New World Cambridge'
update 101_client set comp_name = 'New World Cambridge' where uid_client = 10
Pak'nsave Cameron Rdxx'Pak\'nsave Cameron Rd'
update 101_client set comp_name = 'Pak\'nsave Cameron Rd' where uid_client = 11
Pak'nsave Clarence Streetxx'Pak\'nsave Clarence Street'
update 101_client set comp_name = 'Pak\'nsave Clarence Street' where uid_client = 12
New World Clendonxx'New World Clendon'
update 101_client set comp_name = 'New World Clendon' where uid_client = 13
New World Devonportxx'New World Devonport'
update 101_client set comp_name = 'New World Devonport' where uid_client = 14
New World Eastridgexx'New World Eastridge'
update 101_client set comp_name = 'New World Eastridge' where uid_client = 15
Farro Fresh Foodxx'Farro Fresh Food'
update 101_client set comp_name = 'Farro Fresh Food' where uid_client = 16
Farro Constellationxx'Farro Constellation'
update 101_client set comp_name = 'Farro Constellation' where uid_client = 17
Farro Epsomxx'Farro Epsom'
update 101_client set comp_name = 'Farro Epsom' where uid_client = 18
Farro Fresh Foods Grey Lynnxx'Farro Fresh Foods Grey Lynn'
update 101_client set comp_name = 'Farro Fresh Foods Grey Lynn' where uid_client = 19
Farro Fresh Foods Lunn Avexx'Farro Fresh Foods Lunn Ave'
update 101_client set comp_name = 'Farro Fresh Foods Lunn Ave' where uid_client = 20
Farro Mt Eden xx'Farro Mt Eden '
update 101_client set comp_name = 'Farro Mt Eden ' where uid_client = 21
Farro Orakeixx'Farro Orakei'
update 101_client set comp_name = 'Farro Orakei' where uid_client = 22
Fresh Choice Epsomxx'Fresh Choice Epsom'
update 101_client set comp_name = 'Fresh Choice Epsom' where uid_client = 23
Fresh Choice Glen Edenxx'Fresh Choice Glen Eden'
update 101_client set comp_name = 'Fresh Choice Glen Eden' where uid_client = 24
Fresh Choice Half Moon Bayxx'Fresh Choice Half Moon Bay'
update 101_client set comp_name = 'Fresh Choice Half Moon Bay' where uid_client = 25
Fresh Choice Omokoroaxx'Fresh Choice Omokoroa'
update 101_client set comp_name = 'Fresh Choice Omokoroa' where uid_client = 26
Fresh Choice Ranuixx'Fresh Choice Ranui'
update 101_client set comp_name = 'Fresh Choice Ranui' where uid_client = 27
Fresh Choice Waimaukuxx'Fresh Choice Waimauku'
update 101_client set comp_name = 'Fresh Choice Waimauku' where uid_client = 28
Fresh Collective Albertonxx'Fresh Collective Alberton'
update 101_client set comp_name = 'Fresh Collective Alberton' where uid_client = 29
New World Gate Paxx'New World Gate Pa'
update 101_client set comp_name = 'New World Gate Pa' where uid_client = 30
Pak'nsave Gisbornexx'Pak\'nsave Gisborne'
update 101_client set comp_name = 'Pak\'nsave Gisborne' where uid_client = 31
Pak'nsave Glen Innesxx'Pak\'nsave Glen Innes'
update 101_client set comp_name = 'Pak\'nsave Glen Innes' where uid_client = 32
New World Glenviewxx'New World Glenview'
update 101_client set comp_name = 'New World Glenview' where uid_client = 33
New World Green Bayxx'New World Green Bay'
update 101_client set comp_name = 'New World Green Bay' where uid_client = 34
Pak'nsave Hendersonxx'Pak\'nsave Henderson'
update 101_client set comp_name = 'Pak\'nsave Henderson' where uid_client = 35
New World Hillcrestxx'New World Hillcrest'
update 101_client set comp_name = 'New World Hillcrest' where uid_client = 36
New World Hobsonville xx'New World Hobsonville '
update 101_client set comp_name = 'New World Hobsonville ' where uid_client = 37
New World Howickxx'New World Howick'
update 101_client set comp_name = 'New World Howick' where uid_client = 38
New World Kumeuxx'New World Kumeu'
update 101_client set comp_name = 'New World Kumeu' where uid_client = 39
Fresh Choice Leamingtonxx'Fresh Choice Leamington'
update 101_client set comp_name = 'Fresh Choice Leamington' where uid_client = 40
Pak'nsave Lincoln Northxx'Pak\'nsave Lincoln North'
update 101_client set comp_name = 'Pak\'nsave Lincoln North' where uid_client = 41
New World Long Bayxx'New World Long Bay'
update 101_client set comp_name = 'New World Long Bay' where uid_client = 42
New World Mangawhaixx'New World Mangawhai'
update 101_client set comp_name = 'New World Mangawhai' where uid_client = 43
Pak'nsave Manukauxx'Pak\'nsave Manukau'
update 101_client set comp_name = 'Pak\'nsave Manukau' where uid_client = 44
New World Matamataxx'New World Matamata'
update 101_client set comp_name = 'New World Matamata' where uid_client = 45
New World Metro Shore Cityxx'New World Metro Shore City'
update 101_client set comp_name = 'New World Metro Shore City' where uid_client = 46
New World Milfordxx'New World Milford'
update 101_client set comp_name = 'New World Milford' where uid_client = 47
Pak'nsave Mill Streetxx'Pak\'nsave Mill Street'
update 101_client set comp_name = 'Pak\'nsave Mill Street' where uid_client = 48
New World Morrinsvillexx'New World Morrinsville'
update 101_client set comp_name = 'New World Morrinsville' where uid_client = 49
Pak'nsave Mt Albertxx'Pak\'nsave Mt Albert'
update 101_client set comp_name = 'Pak\'nsave Mt Albert' where uid_client = 50
New World Mt Maunganuixx'New World Mt Maunganui'
update 101_client set comp_name = 'New World Mt Maunganui' where uid_client = 51
New World Mt Roskillxx'New World Mt Roskill'
update 101_client set comp_name = 'New World Mt Roskill' where uid_client = 52
New World New Lynnxx'New World New Lynn'
update 101_client set comp_name = 'New World New Lynn' where uid_client = 53
New World Opotikixx'New World Opotiki'
update 101_client set comp_name = 'New World Opotiki' where uid_client = 54
New World Orewaxx'New World Orewa'
update 101_client set comp_name = 'New World Orewa' where uid_client = 55
New World Ormistonxx'New World Ormiston'
update 101_client set comp_name = 'New World Ormiston' where uid_client = 56
Pak'nsave Ormistonxx'Pak\'nsave Ormiston'
update 101_client set comp_name = 'Pak\'nsave Ormiston' where uid_client = 57
Super Value Paetiki Taupoxx'Super Value Paetiki Taupo'
update 101_client set comp_name = 'Super Value Paetiki Taupo' where uid_client = 58
New World Papakuraxx'New World Papakura'
update 101_client set comp_name = 'New World Papakura' where uid_client = 59
Pak'nsave Papakuraxx'Pak\'nsave Papakura'
update 101_client set comp_name = 'Pak\'nsave Papakura' where uid_client = 60
Fresh Choice Papamoaxx'Fresh Choice Papamoa'
update 101_client set comp_name = 'Fresh Choice Papamoa' where uid_client = 61
Pak'nsave Papamoaxx'Pak\'nsave Papamoa'
update 101_client set comp_name = 'Pak\'nsave Papamoa' where uid_client = 62
New World Papatoetoexx'New World Papatoetoe'
update 101_client set comp_name = 'New World Papatoetoe' where uid_client = 63
New World Pukekohexx'New World Pukekohe'
update 101_client set comp_name = 'New World Pukekohe' where uid_client = 64
Pak'nsave Pukekohexx'Pak\'nsave Pukekohe'
update 101_client set comp_name = 'Pak\'nsave Pukekohe' where uid_client = 65
New World Remueraxx'New World Remuera'
update 101_client set comp_name = 'New World Remuera' where uid_client = 66
Pak'nsave Rotoruaxx'Pak\'nsave Rotorua'
update 101_client set comp_name = 'Pak\'nsave Rotorua' where uid_client = 67
New World Rototunaxx'New World Rototuna'
update 101_client set comp_name = 'New World Rototuna' where uid_client = 68
Pak'nsave Royal Oakxx'Pak\'nsave Royal Oak'
update 101_client set comp_name = 'Pak\'nsave Royal Oak' where uid_client = 69
New World Shore Cityxx'New World Shore City'
update 101_client set comp_name = 'New World Shore City' where uid_client = 70
Pak'nsave Silverdalexx'Pak\'nsave Silverdale'
update 101_client set comp_name = 'Pak\'nsave Silverdale' where uid_client = 71
New World Southmall xx'New World Southmall '
update 101_client set comp_name = 'New World Southmall ' where uid_client = 72
New World Stonefieldsxx'New World Stonefields'
update 101_client set comp_name = 'New World Stonefields' where uid_client = 73
Pak'nsave Sylvia Parkxx'Pak\'nsave Sylvia Park'
update 101_client set comp_name = 'Pak\'nsave Sylvia Park' where uid_client = 74
New World Taumarunuixx'New World Taumarunui'
update 101_client set comp_name = 'New World Taumarunui' where uid_client = 75
Pak'nsave Taupoxx'Pak\'nsave Taupo'
update 101_client set comp_name = 'Pak\'nsave Taupo' where uid_client = 76
Pak'nsave Taurikoxx'Pak\'nsave Tauriko'
update 101_client set comp_name = 'Pak\'nsave Tauriko' where uid_client = 77
Fresh Choice Te Awamutuxx'Fresh Choice Te Awamutu'
update 101_client set comp_name = 'Fresh Choice Te Awamutu' where uid_client = 78
Pak'nsave Te Awamutuxx'Pak\'nsave Te Awamutu'
update 101_client set comp_name = 'Pak\'nsave Te Awamutu' where uid_client = 79
New World Te Pukexx'New World Te Puke'
update 101_client set comp_name = 'New World Te Puke' where uid_client = 80
New World Te Rapaxx'New World Te Rapa'
update 101_client set comp_name = 'New World Te Rapa' where uid_client = 81
Pak'nsave Thamesxx'Pak\'nsave Thames'
update 101_client set comp_name = 'Pak\'nsave Thames' where uid_client = 82
New World Turangixx'New World Turangi'
update 101_client set comp_name = 'New World Turangi' where uid_client = 83
New World Victoria Parkxx'New World Victoria Park'
update 101_client set comp_name = 'New World Victoria Park' where uid_client = 84
New World Waihixx'New World Waihi'
update 101_client set comp_name = 'New World Waihi' where uid_client = 85
Pak'nsave Wairau Road 615862xx'Pak\'nsave Wairau Road 615862'
update 101_client set comp_name = 'Pak\'nsave Wairau Road 615862' where uid_client = 86
New World Waiukuxx'New World Waiuku'
update 101_client set comp_name = 'New World Waiuku' where uid_client = 87
New World Warkworthxx'New World Warkworth'
update 101_client set comp_name = 'New World Warkworth' where uid_client = 88
Pak'nsave Westgatexx'Pak\'nsave Westgate'
update 101_client set comp_name = 'Pak\'nsave Westgate' where uid_client = 89
New World Westendxx'New World Westend'
update 101_client set comp_name = 'New World Westend' where uid_client = 90
New World Whakatanexx'New World Whakatane'
update 101_client set comp_name = 'New World Whakatane' where uid_client = 91
Pak'nsave Whakatanexx'Pak\'nsave Whakatane'
update 101_client set comp_name = 'Pak\'nsave Whakatane' where uid_client = 92
New World Whangamataxx'New World Whangamata'
update 101_client set comp_name = 'New World Whangamata' where uid_client = 93
New World Whangaparaoaxx'New World Whangaparaoa'
update 101_client set comp_name = 'New World Whangaparaoa' where uid_client = 94
Pak'nsave Whangareixx'Pak\'nsave Whangarei'
update 101_client set comp_name = 'Pak\'nsave Whangarei' where uid_client = 95
New World Whangarei Regentxx'New World Whangarei Regent'
update 101_client set comp_name = 'New World Whangarei Regent' where uid_client = 96
Four Square Akaroaxx'Four Square Akaroa'
update 101_client set comp_name = 'Four Square Akaroa' where uid_client = 97
Four Square Amberleyxx'Four Square Amberley'
update 101_client set comp_name = 'Four Square Amberley' where uid_client = 98
Supervalue Edgeware Villagexx'Supervalue Edgeware Village'
update 101_client set comp_name = 'Supervalue Edgeware Village' where uid_client = 99
Four Square Fairlexx'Four Square Fairle'
update 101_client set comp_name = 'Four Square Fairle' where uid_client = 100
Four Square Cheviotxx'Four Square Cheviot'
update 101_client set comp_name = 'Four Square Cheviot' where uid_client = 101
Four Square Rosebankxx'Four Square Rosebank'
update 101_client set comp_name = 'Four Square Rosebank' where uid_client = 102
Four Square Te Anauxx'Four Square Te Anau'
update 101_client set comp_name = 'Four Square Te Anau' where uid_client = 103
Fresh Choice Barringtonxx'Fresh Choice Barrington'
update 101_client set comp_name = 'Fresh Choice Barrington' where uid_client = 104
Fresh Choice Dunedinxx'Fresh Choice Dunedin'
update 101_client set comp_name = 'Fresh Choice Dunedin' where uid_client = 105
Fresh Choice Geraldinexx'Fresh Choice Geraldine'
update 101_client set comp_name = 'Fresh Choice Geraldine' where uid_client = 106
Fresh Choice Merivalexx'Fresh Choice Merivale'
update 101_client set comp_name = 'Fresh Choice Merivale' where uid_client = 107
Fresh Choice Nelsonxx'Fresh Choice Nelson'
update 101_client set comp_name = 'Fresh Choice Nelson' where uid_client = 108
Fresh Choice Parklandsxx'Fresh Choice Parklands'
update 101_client set comp_name = 'Fresh Choice Parklands' where uid_client = 109
Fresh Choice Pictonxx'Fresh Choice Picton'
update 101_client set comp_name = 'Fresh Choice Picton' where uid_client = 110
Fresh Choice Queenstownxx'Fresh Choice Queenstown'
update 101_client set comp_name = 'Fresh Choice Queenstown' where uid_client = 111
Fresh Choice Richmondxx'Fresh Choice Richmond'
update 101_client set comp_name = 'Fresh Choice Richmond' where uid_client = 112
Fresh Choice Takakaxx'Fresh Choice Takaka'
update 101_client set comp_name = 'Fresh Choice Takaka' where uid_client = 113
Morgans Road Supermarketxx'Morgans Road Supermarket'
update 101_client set comp_name = 'Morgans Road Supermarket' where uid_client = 114
New World Alexandraxx'New World Alexandra'
update 101_client set comp_name = 'New World Alexandra' where uid_client = 115
New World Ashburtonxx'New World Ashburton'
update 101_client set comp_name = 'New World Ashburton' where uid_client = 116
New World Balcluthaxx'New World Balclutha'
update 101_client set comp_name = 'New World Balclutha' where uid_client = 117
New World Bishopdalexx'New World Bishopdale'
update 101_client set comp_name = 'New World Bishopdale' where uid_client = 118
New World Blenheimxx'New World Blenheim'
update 101_client set comp_name = 'New World Blenheim' where uid_client = 119
New World Centre City Dunedinxx'New World Centre City Dunedin'
update 101_client set comp_name = 'New World Centre City Dunedin' where uid_client = 120
New World Cromwellxx'New World Cromwell'
update 101_client set comp_name = 'New World Cromwell' where uid_client = 121
New World Elles Rdxx'New World Elles Rd'
update 101_client set comp_name = 'New World Elles Rd' where uid_client = 122
New World Fendaltonxx'New World Fendalton'
update 101_client set comp_name = 'New World Fendalton' where uid_client = 123
New World Ferry Roadxx'New World Ferry Road'
update 101_client set comp_name = 'New World Ferry Road' where uid_client = 124
New World Gardensxx'New World Gardens'
update 101_client set comp_name = 'New World Gardens' where uid_client = 125
New World Gorexx'New World Gore'
update 101_client set comp_name = 'New World Gore' where uid_client = 126
New World Greymouthxx'New World Greymouth'
update 101_client set comp_name = 'New World Greymouth' where uid_client = 127
New World Halswellxx'New World Halswell'
update 101_client set comp_name = 'New World Halswell' where uid_client = 128
New World Hokitikaxx'New World Hokitika'
update 101_client set comp_name = 'New World Hokitika' where uid_client = 129
New World Ilamxx'New World Ilam'
update 101_client set comp_name = 'New World Ilam' where uid_client = 130
New World Kaiapoixx'New World Kaiapoi'
update 101_client set comp_name = 'New World Kaiapoi' where uid_client = 131
New World Kaikouraxx'New World Kaikoura'
update 101_client set comp_name = 'New World Kaikoura' where uid_client = 132
New World Lincolnxx'New World Lincoln'
update 101_client set comp_name = 'New World Lincoln' where uid_client = 133
New World Mosgielxx'New World Mosgiel'
update 101_client set comp_name = 'New World Mosgiel' where uid_client = 134
New World Motuekaxx'New World Motueka'
update 101_client set comp_name = 'New World Motueka' where uid_client = 135
New World Nelson Cityxx'New World Nelson City'
update 101_client set comp_name = 'New World Nelson City' where uid_client = 136
New World Northwoodxx'New World Northwood'
update 101_client set comp_name = 'New World Northwood' where uid_client = 137
New World Oamaruxx'New World Oamaru'
update 101_client set comp_name = 'New World Oamaru' where uid_client = 138
New World Prestonsxx'New World Prestons'
update 101_client set comp_name = 'New World Prestons' where uid_client = 139
New World Queenstown Wakatipuxx'New World Queenstown Wakatipu'
update 101_client set comp_name = 'New World Queenstown Wakatipu' where uid_client = 140
New World Rangiora xx'New World Rangiora '
update 101_client set comp_name = 'New World Rangiora ' where uid_client = 141
New World Ravenswoodxx'New World Ravenswood'
update 101_client set comp_name = 'New World Ravenswood' where uid_client = 142
New World Rollestonxx'New World Rolleston'
update 101_client set comp_name = 'New World Rolleston' where uid_client = 143
New World St Martinsxx'New World St Martins'
update 101_client set comp_name = 'New World St Martins' where uid_client = 144
New World Stanmorexx'New World Stanmore'
update 101_client set comp_name = 'New World Stanmore' where uid_client = 145
New World Stokexx'New World Stoke'
update 101_client set comp_name = 'New World Stoke' where uid_client = 146
New World Temukaxx'New World Temuka'
update 101_client set comp_name = 'New World Temuka' where uid_client = 147
New World Three Parksxx'New World Three Parks'
update 101_client set comp_name = 'New World Three Parks' where uid_client = 148
New World Timaruxx'New World Timaru'
update 101_client set comp_name = 'New World Timaru' where uid_client = 149
New World Waimatexx'New World Waimate'
update 101_client set comp_name = 'New World Waimate' where uid_client = 150
New World Waitakixx'New World Waitaki'
update 101_client set comp_name = 'New World Waitaki' where uid_client = 151
New World Wanakaxx'New World Wanaka'
update 101_client set comp_name = 'New World Wanaka' where uid_client = 152
New World Westportxx'New World Westport'
update 101_client set comp_name = 'New World Westport' where uid_client = 153
New World Wigramxx'New World Wigram'
update 101_client set comp_name = 'New World Wigram' where uid_client = 154
New World Windsorxx'New World Windsor'
update 101_client set comp_name = 'New World Windsor' where uid_client = 155
New World Wintonxx'New World Winton'
update 101_client set comp_name = 'New World Winton' where uid_client = 156
New World Durham Stxx'New World Durham St'
update 101_client set comp_name = 'New World Durham St' where uid_client = 157
Pak'nsave Dunedinxx'Pak\'nsave Dunedin'
update 101_client set comp_name = 'Pak\'nsave Dunedin' where uid_client = 158
Pak'nsave Blenheimxx'Pak\'nsave Blenheim'
update 101_client set comp_name = 'Pak\'nsave Blenheim' where uid_client = 159
Pak'nsave Hornbyxx'Pak\'nsave Hornby'
update 101_client set comp_name = 'Pak\'nsave Hornby' where uid_client = 160
Pak'nsave Invercargillxx'Pak\'nsave Invercargill'
update 101_client set comp_name = 'Pak\'nsave Invercargill' where uid_client = 161
Pak'nsave Moorhousexx'Pak\'nsave Moorhouse'
update 101_client set comp_name = 'Pak\'nsave Moorhouse' where uid_client = 162
Pak'nsave Papanuixx'Pak\'nsave Papanui'
update 101_client set comp_name = 'Pak\'nsave Papanui' where uid_client = 163
Pak'nsave Queenstownxx'Pak\'nsave Queenstown'
update 101_client set comp_name = 'Pak\'nsave Queenstown' where uid_client = 164
Pak'nsave Rangioraxx'Pak\'nsave Rangiora'
update 101_client set comp_name = 'Pak\'nsave Rangiora' where uid_client = 165
Pak'nsave Riccartonxx'Pak\'nsave Riccarton'
update 101_client set comp_name = 'Pak\'nsave Riccarton' where uid_client = 166
Pak'nsave Richmondxx'Pak\'nsave Richmond'
update 101_client set comp_name = 'Pak\'nsave Richmond' where uid_client = 167
Pak'nsave Timaruxx'Pak\'nsave Timaru'
update 101_client set comp_name = 'Pak\'nsave Timaru' where uid_client = 168
Pak'nsave Wainonixx'Pak\'nsave Wainoni'
update 101_client set comp_name = 'Pak\'nsave Wainoni' where uid_client = 169
Raeware Fresh Harewood Rdxx'Raeware Fresh Harewood Rd'
update 101_client set comp_name = 'Raeware Fresh Harewood Rd' where uid_client = 170
Raeward Fresh Queenstownxx'Raeward Fresh Queenstown'
update 101_client set comp_name = 'Raeward Fresh Queenstown' where uid_client = 171
Raeword Fresh Richmondxx'Raeword Fresh Richmond'
update 101_client set comp_name = 'Raeword Fresh Richmond' where uid_client = 172
Raeward Fresh Tower Junctionxx'Raeward Fresh Tower Junction'
update 101_client set comp_name = 'Raeward Fresh Tower Junction' where uid_client = 173
Four Square Tapanuixx'Four Square Tapanui'
update 101_client set comp_name = 'Four Square Tapanui' where uid_client = 174
Four Square Tuaraperexx'Four Square Tuarapere'
update 101_client set comp_name = 'Four Square Tuarapere' where uid_client = 175
Four Square Westonxx'Four Square Weston'
update 101_client set comp_name = 'Four Square Weston' where uid_client = 176
New World Aokauterexx'New World Aokautere'
update 101_client set comp_name = 'New World Aokautere' where uid_client = 177
Four Square Awapunixx'Four Square Awapuni'
update 101_client set comp_name = 'Four Square Awapuni' where uid_client = 178
New World Broadway xx'New World Broadway '
update 101_client set comp_name = 'New World Broadway ' where uid_client = 179
New World Carterton xx'New World Carterton '
update 101_client set comp_name = 'New World Carterton ' where uid_client = 180
New World Churton Parkxx'New World Churton Park'
update 101_client set comp_name = 'New World Churton Park' where uid_client = 181
New World Dannevirkexx'New World Dannevirke'
update 101_client set comp_name = 'New World Dannevirke' where uid_client = 182
New World Feildingxx'New World Feilding'
update 101_client set comp_name = 'New World Feilding' where uid_client = 183
New World Flaxmerexx'New World Flaxmere'
update 101_client set comp_name = 'New World Flaxmere' where uid_client = 184
New World Foxtonxx'New World Foxton'
update 101_client set comp_name = 'New World Foxton' where uid_client = 185
Fresh Choice Greytownxx'Fresh Choice Greytown'
update 101_client set comp_name = 'Fresh Choice Greytown' where uid_client = 186
Gina Fresh Producexx'Gina Fresh Produce'
update 101_client set comp_name = 'Gina Fresh Produce' where uid_client = 187
New World Greenmeadowsxx'New World Greenmeadows'
update 101_client set comp_name = 'New World Greenmeadows' where uid_client = 188
New World Hastingsxx'New World Hastings'
update 101_client set comp_name = 'New World Hastings' where uid_client = 189
Pak'nsave Hastingsxx'Pak\'nsave Hastings'
update 101_client set comp_name = 'Pak\'nsave Hastings' where uid_client = 190
New World Havelock Northxx'New World Havelock North'
update 101_client set comp_name = 'New World Havelock North' where uid_client = 191
Pak'nsave Haweraxx'Pak\'nsave Hawera'
update 101_client set comp_name = 'Pak\'nsave Hawera' where uid_client = 192
New World Hutt Cityxx'New World Hutt City'
update 101_client set comp_name = 'New World Hutt City' where uid_client = 193
Pak'nsave Lower Hutt Cityxx'Pak\'nsave Lower Hutt City'
update 101_client set comp_name = 'Pak\'nsave Lower Hutt City' where uid_client = 194
New World Island Bayxx'New World Island Bay'
update 101_client set comp_name = 'New World Island Bay' where uid_client = 195
New World Kapitixx'New World Kapiti'
update 101_client set comp_name = 'New World Kapiti' where uid_client = 196
Pak'nsave Kapitixx'Pak\'nsave Kapiti'
update 101_client set comp_name = 'Pak\'nsave Kapiti' where uid_client = 197
New World Karorixx'New World Karori'
update 101_client set comp_name = 'New World Karori' where uid_client = 198
New World Khandallahxx'New World Khandallah'
update 101_client set comp_name = 'New World Khandallah' where uid_client = 199
Pak'nsave Kilbirniexx'Pak\'nsave Kilbirnie'
update 101_client set comp_name = 'Pak\'nsave Kilbirnie' where uid_client = 200
Pak'nsave Mini Levinxx'Pak\'nsave Mini Levin'
update 101_client set comp_name = 'Pak\'nsave Mini Levin' where uid_client = 201
New World Levinxx'New World Levin'
update 101_client set comp_name = 'New World Levin' where uid_client = 202
Four Square Martinboroughxx'Four Square Martinborough'
update 101_client set comp_name = 'Four Square Martinborough' where uid_client = 203
New World Martonxx'New World Marton'
update 101_client set comp_name = 'New World Marton' where uid_client = 204
New World Mastertonxx'New World Masterton'
update 101_client set comp_name = 'New World Masterton' where uid_client = 205
Pak'nsave Mastertonxx'Pak\'nsave Masterton'
update 101_client set comp_name = 'Pak\'nsave Masterton' where uid_client = 206
New World Merrilandsxx'New World Merrilands'
update 101_client set comp_name = 'New World Merrilands' where uid_client = 207
New World Miramarxx'New World Miramar'
update 101_client set comp_name = 'New World Miramar' where uid_client = 208
Moore Wilson & Co Ltdxx'Moore Wilson & Co Ltd'
update 101_client set comp_name = 'Moore Wilson & Co Ltd' where uid_client = 209
Pak'nsave Napierxx'Pak\'nsave Napier'
update 101_client set comp_name = 'Pak\'nsave Napier' where uid_client = 210
New World New Plymouthxx'New World New Plymouth'
update 101_client set comp_name = 'New World New Plymouth' where uid_client = 211
Pak'nsave New Plymouthxx'Pak\'nsave New Plymouth'
update 101_client set comp_name = 'Pak\'nsave New Plymouth' where uid_client = 212
New World Newlandsxx'New World Newlands'
update 101_client set comp_name = 'New World Newlands' where uid_client = 213
New World Newtown (426401)xx'New World Newtown (426401)'
update 101_client set comp_name = 'New World Newtown (426401)' where uid_client = 214
New World Ohakune xx'New World Ohakune '
update 101_client set comp_name = 'New World Ohakune ' where uid_client = 215
New World Onekawaxx'New World Onekawa'
update 101_client set comp_name = 'New World Onekawa' where uid_client = 216
New World Otakixx'New World Otaki'
update 101_client set comp_name = 'New World Otaki' where uid_client = 217
New World Pahiatuaxx'New World Pahiatua'
update 101_client set comp_name = 'New World Pahiatua' where uid_client = 218
Pak'nsave Palmerston Northxx'Pak\'nsave Palmerston North'
update 101_client set comp_name = 'Pak\'nsave Palmerston North' where uid_client = 219
New World Paremataxx'New World Paremata'
update 101_client set comp_name = 'New World Paremata' where uid_client = 220
Penray Gardensxx'Penray Gardens'
update 101_client set comp_name = 'Penray Gardens' where uid_client = 221
Pak'nsave Petonexx'Pak\'nsave Petone'
update 101_client set comp_name = 'Pak\'nsave Petone' where uid_client = 222
New World Pioneerxx'New World Pioneer'
update 101_client set comp_name = 'New World Pioneer' where uid_client = 223
New World Porirua Cityxx'New World Porirua City'
update 101_client set comp_name = 'New World Porirua City' where uid_client = 224
Pak'nsave Poriruaxx'Pak\'nsave Porirua'
update 101_client set comp_name = 'Pak\'nsave Porirua' where uid_client = 225
New World Railway Metroxx'New World Railway Metro'
update 101_client set comp_name = 'New World Railway Metro' where uid_client = 226
Shoprite Inglewoodxx'Shoprite Inglewood'
update 101_client set comp_name = 'Shoprite Inglewood' where uid_client = 227
New World Silverstreamxx'New World Silverstream'
update 101_client set comp_name = 'New World Silverstream' where uid_client = 228
New World Stokes Valleyxx'New World Stokes Valley'
update 101_client set comp_name = 'New World Stokes Valley' where uid_client = 229
New World Stratfordxx'New World Stratford'
update 101_client set comp_name = 'New World Stratford' where uid_client = 230
New World Taihapexx'New World Taihape'
update 101_client set comp_name = 'New World Taihape' where uid_client = 231
Pak'nsave Tamateaxx'Pak\'nsave Tamatea'
update 101_client set comp_name = 'Pak\'nsave Tamatea' where uid_client = 232
New World Tawaxx'New World Tawa'
update 101_client set comp_name = 'New World Tawa' where uid_client = 233
New World Thorndonxx'New World Thorndon'
update 101_client set comp_name = 'New World Thorndon' where uid_client = 234
Pak'nsave Upper Huttxx'Pak\'nsave Upper Hutt'
update 101_client set comp_name = 'Pak\'nsave Upper Hutt' where uid_client = 235
New World Waikanaexx'New World Waikanae'
update 101_client set comp_name = 'New World Waikanae' where uid_client = 236
New World Waipawaxx'New World Waipawa'
update 101_client set comp_name = 'New World Waipawa' where uid_client = 237
New World Waipukurauxx'New World Waipukurau'
update 101_client set comp_name = 'New World Waipukurau' where uid_client = 238
Write Price Wairoaxx'Write Price Wairoa'
update 101_client set comp_name = 'Write Price Wairoa' where uid_client = 239
New World Wairoaxx'New World Wairoa'
update 101_client set comp_name = 'New World Wairoa' where uid_client = 240
New World Waitaraxx'New World Waitara'
update 101_client set comp_name = 'New World Waitara' where uid_client = 241
Pak'nsave Whanganuixx'Pak\'nsave Whanganui'
update 101_client set comp_name = 'Pak\'nsave Whanganui' where uid_client = 242
New World Wellington Cityxx'New World Wellington City'
update 101_client set comp_name = 'New World Wellington City' where uid_client = 243
New World Whanganuixx'New World Whanganui'
update 101_client set comp_name = 'New World Whanganui' where uid_client = 244
New World Whitby xx'New World Whitby '
update 101_client set comp_name = 'New World Whitby ' where uid_client = 245
New World Metro Willis Streetxx'New World Metro Willis Street'
update 101_client set comp_name = 'New World Metro Willis Street' where uid_client = 246
New World Testxx'New World Test'
update 101_client set comp_name = 'New World Test' where uid_client = 247
Four Square St Clairxx'Four Square St Clair'
update 101_client set comp_name = 'Four Square St Clair' where uid_client = 248
Pak'nsave Warkworthxx'Pak\'nsave Warkworth'
update 101_client set comp_name = 'Pak\'nsave Warkworth' where uid_client = 249
New World Newmarketxx'New World Newmarket'
update 101_client set comp_name = 'New World Newmarket' where uid_client = 250
New World The Sandsxx'New World The Sands'
update 101_client set comp_name = 'New World The Sands' where uid_client = 251
Pak'nsave Highland Parkxx'Pak\'nsave Highland Park'
update 101_client set comp_name = 'Pak\'nsave Highland Park' where uid_client = 252