update tb_InvoiceItem set col_upgradeID=332 where col_Description='A La Carte: Under-Cabinet Lighting - UPG - Add Under-Cabinet Lighting'; update tb_InvoiceItem set col_upgradeID=333 where col_Description='remove'; update tb_InvoiceItem set col_upgradeID=334 where col_Description='remove'; update tb_InvoiceItem set col_upgradeID=335 where col_Description='Ensuite Bathroom: Cabinets - PRM Dark - Metallic Elm EuroGloss'; update tb_InvoiceItem set col_upgradeID=336 where col_Description='Ensuite Bathroom: Cabinets - PRM Light - Milano Walnut EuroGloss'; update tb_InvoiceItem set col_upgradeID=337 where col_Description='Ensuite Bathroom: Cabinets - STD Dark - Noce Milano'; update tb_InvoiceItem set col_upgradeID=338 where col_Description='Ensuite Bathroom: Cabinets - STD Light - Urban Oak'; update tb_InvoiceItem set col_upgradeID=339 where col_Description='Ensuite Bathroom: Cabinets - UPG Dark - Metallic Elm EuroGloss'; update tb_InvoiceItem set col_upgradeID=340 where col_Description='Ensuite Bathroom: Cabinets - UPG Light - Milano Walnut EuroGloss'; update tb_InvoiceItem set col_upgradeID=341 where col_Description='Ensuite Bathroom: Counter - Dark - Solid S04 Steel'; update tb_InvoiceItem set col_upgradeID=342 where col_Description='Ensuite Bathroom: Counter - Light - Solid S09 White'; update tb_InvoiceItem set col_upgradeID=343 where col_Description='Ensuite Bathroom: Floor Tiles - PRM Dark - Blue Paver Honed - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=344 where col_Description='Ensuite Bathroom: Floor Tiles - PRM Light - Bottochino Honed - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=345 where col_Description='Ensuite Bathroom: Floor Tiles - STD Dark - Coal Matte - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=345 where col_Description='Ensuite Bathroom: Floor Tiles - STD Dark - Griogio Carnico Honed 12” x 24”'; update tb_InvoiceItem set col_upgradeID=346 where col_Description='Ensuite Bathroom: Floor Tiles - STD Light - Beige Matte - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=346 where col_Description='Ensuite Bathroom: Floor Tiles - STD Light - Crema Luna Honed - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=347 where col_Description='Ensuite Bathroom: Floor Tiles - UPG Dark - Coal Matte - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=348 where col_Description='Ensuite Bathroom: Floor Tiles - UPG Light - Beige Matte - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=348 where col_Description='Ensuite Bathroom: Floor Tiles - UPG Light - Crema Luna Honed 12” x 24”'; update tb_InvoiceItem set col_upgradeID=349 where col_Description='Ensuite Bathroom: Wall Tiles - PRM - Dolomite White Polished - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=350 where col_Description='Ensuite Bathroom: Wall Tiles - STD - Bianco Polished - 4" x 16"'; update tb_InvoiceItem set col_upgradeID=350 where col_Description='Ensuite Bathroom: Wall Tiles - STD - Carrara White Lux Polished - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=351 where col_Description='Ensuite Bathroom: Wall Tiles - UPG - Bianco Polished - 4" x 16"'; update tb_InvoiceItem set col_upgradeID=352 where col_Description='Ensuite Bathroom: Wall Tiles - UPG - Oriental White Polished 12” x 24” '; update tb_InvoiceItem set col_upgradeID=353 where col_Description='Kitchen: Backsplash - PRM Dark - Black Mist Polished'; update tb_InvoiceItem set col_upgradeID=354 where col_Description='Kitchen: Backsplash - PRM Light - White Alamo Polished'; update tb_InvoiceItem set col_upgradeID=355 where col_Description='Kitchen: Backsplash - STD Dark - Nero Matte - 5 x 25 cm'; update tb_InvoiceItem set col_upgradeID=356 where col_Description='Kitchen: Backsplash - STD Light - Bianco Matte - 5 x 25 cm'; update tb_InvoiceItem set col_upgradeID=357 where col_Description='Kitchen: Backsplash - UPG Dark - Black Gloss - 4.8 X 30 Cm'; update tb_InvoiceItem set col_upgradeID=358 where col_Description='Kitchen: Backsplash - UPG Light - White Gloss - 4.8 x 30 cm'; update tb_InvoiceItem set col_upgradeID=359 where col_Description='Kitchen: Cabinets - PRM Dark - Metallic Elm EuroGloss/Storm Grey EuroGloss'; update tb_InvoiceItem set col_upgradeID=360 where col_Description='Kitchen: Cabinets - PRM Light - Milano Walnut EuroGloss/White EuroGloss'; update tb_InvoiceItem set col_upgradeID=361 where col_Description='Kitchen: Cabinets - STD Dark - Noce Milano/Diamond Grey'; update tb_InvoiceItem set col_upgradeID=362 where col_Description='Kitchen: Cabinets - STD Light - Urban Oak/Premium White'; update tb_InvoiceItem set col_upgradeID=363 where col_Description='Kitchen: Cabinets - UPG Dark - Metallic Elm EuroGloss/Storm Grey EuroGloss'; update tb_InvoiceItem set col_upgradeID=364 where col_Description='Kitchen: Cabinets - UPG Light - Milano Walnut EuroGloss/White EuroGloss'; update tb_InvoiceItem set col_upgradeID=365 where col_Description='Kitchen: Counter - Dark - Black Mist Polished'; update tb_InvoiceItem set col_upgradeID=366 where col_Description='Kitchen: Counter - Light - White Alamo Polished'; update tb_InvoiceItem set col_upgradeID=367 where col_Description='Kitchen: Flooring - PRM Dark - Spiked Ice'; update tb_InvoiceItem set col_upgradeID=368 where col_Description='Kitchen: Flooring - PRM Light - Coconut Chai'; update tb_InvoiceItem set col_upgradeID=369 where col_Description='Kitchen: Flooring - STD Dark - Bravo'; update tb_InvoiceItem set col_upgradeID=370 where col_Description='Kitchen: Flooring - STD Light - Griggio'; update tb_InvoiceItem set col_upgradeID=371 where col_Description='Kitchen: Flooring - UPG Dark - Spiked Ice'; update tb_InvoiceItem set col_upgradeID=372 where col_Description='Kitchen: Flooring - UPG Light - Coconut Chai'; update tb_InvoiceItem set col_upgradeID=373 where col_Description='Main Bathroom: Cabinets - PRM Dark - Metallic Elm EuroGloss'; update tb_InvoiceItem set col_upgradeID=374 where col_Description='Main Bathroom: Cabinets - PRM Light - White EuroGloss'; update tb_InvoiceItem set col_upgradeID=375 where col_Description='Main Bathroom: Cabinets - STD Dark - Noce Milano'; update tb_InvoiceItem set col_upgradeID=376 where col_Description='Main Bathroom: Cabinets - STD Light - Premium White'; update tb_InvoiceItem set col_upgradeID=377 where col_Description='Main Bathroom: Cabinets - UPG Dark - Metallic Elm EuroGloss'; update tb_InvoiceItem set col_upgradeID=378 where col_Description='Main Bathroom: Cabinets - UPG Light - White EuroGloss'; update tb_InvoiceItem set col_upgradeID=379 where col_Description='Main Bathroom: Counter - Solid S09 White'; update tb_InvoiceItem set col_upgradeID=380 where col_Description='Main Bathroom: Floor Tiles - PRM Dark - Grigio Carnico Honed - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=381 where col_Description='Main Bathroom: Floor Tiles - PRM Light - Oriental White Polished'; update tb_InvoiceItem set col_upgradeID=382 where col_Description='Main Bathroom: Floor Tiles - STD Dark - Charcoal Matte - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=383 where col_Description='Main Bathroom: Floor Tiles - STD Light - Silver Matte - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=384 where col_Description='Main Bathroom: Floor Tiles - UPG Dark - Charcoal Matte - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=385 where col_Description='Main Bathroom: Floor Tiles - UPG Light - Silver Matte - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=386 where col_Description='Main Bathroom: Medicine Cabinet - PRM Dark - Storm Grey EuroGloss'; update tb_InvoiceItem set col_upgradeID=387 where col_Description='Main Bathroom: Medicine Cabinet - PRM Light - White EuroGloss'; update tb_InvoiceItem set col_upgradeID=388 where col_Description='Main Bathroom: Medicine Cabinet - STD Dark - Diamond Grey'; update tb_InvoiceItem set col_upgradeID=389 where col_Description='Main Bathroom: Medicine Cabinet - STD Light - Premium White'; update tb_InvoiceItem set col_upgradeID=390 where col_Description='Main Bathroom: Medicine Cabinet - UPG Dark - Storm Grey EuroGloss'; update tb_InvoiceItem set col_upgradeID=391 where col_Description='Main Bathroom: Medicine Cabinet - UPG Light - White EuroGloss'; update tb_InvoiceItem set col_upgradeID=392 where col_Description='Main Bathroom: Shower Floor Tiles - Bianco Porcelain'; update tb_InvoiceItem set col_upgradeID=393 where col_Description='Main Bathroom: Wall Tiles - PRM - Dolomite White Polished - 12" x 24"'; update tb_InvoiceItem set col_upgradeID=394 where col_Description='Main Bathroom: Wall Tiles - STD - Bianco Polished - 4" x 16"'; update tb_InvoiceItem set col_upgradeID=394 where col_Description='Main Bathroom: Wall Tiles - STD - Superbianco Polished'; update tb_InvoiceItem set col_upgradeID=395 where col_Description='Main Bathroom: Wall Tiles - UPG - Bianco Polished - 4" x 16"'; update tb_InvoiceItem set col_upgradeID=396 where col_Description='Main Bathroom: Wall Tiles - UPG - Superbianco Polished'; update tb_InvoiceItem set col_upgradeID=397 where col_Description='Ensuite Bathroom: Shower Floor Tiles - Bianco Porcelain'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1205 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '320'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1205 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '420'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1205 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '520'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1205 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '620'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1205 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '720'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1157 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '805'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '910'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1010'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1110'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1210'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1310'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1410'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1510'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1610'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1710'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1810'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1910'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2010'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2110'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2210'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2310'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2410'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2510'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2610'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2710'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2810'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2910'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3010'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3110'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1290 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3210'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=4253 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '220+221'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '734'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '817'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '924'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1024'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1124'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1224'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1324'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1424'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1524'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1624'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2186 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '230'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2186 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '330'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2186 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '430'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2186 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '530'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2186 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '630'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '238'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '338'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '438'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '538'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '638'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2986 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '206'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2986 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '209'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2986 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '306'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2986 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '309'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2986 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '406'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2986 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '409'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2986 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '506'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2986 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '509'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2986 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '606'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2986 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '609'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2986 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '706'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2986 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '709'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '901'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1001'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1101'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1201'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1301'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1401'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1501'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1601'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1701'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1801'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1901'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2001'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2101'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2201'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2301'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2401'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2501'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2601'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2701'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2801'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2901'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3001'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3101'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1142 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3201'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1166 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '723'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1166 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '806'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1166 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '913'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1166 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1013'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1166 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1113'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1166 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1213'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1166 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1313'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1166 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1413'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1166 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1513'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1166 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1613'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '725'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '808'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '915'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1015'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1115'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1215'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1315'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1415'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1515'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=4008 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1615+1616'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '235'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '335'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '435'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '535'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '635'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '731'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '814'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1021'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1121'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1221'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1321'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1421'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1521'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1120 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1621'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '219'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '319'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '419'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '519'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '619'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '719'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '804'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '909'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1009'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1109'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1209'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1309'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1409'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1509'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1609'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1709'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1809'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1909'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2009'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2109'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2209'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2309'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2409'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2509'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2609'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2709'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2809'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2909'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3009'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3109'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3209'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '229'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '329'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '429'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '529'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=851 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '629'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2477 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '225'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2477 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '325'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2477 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '425'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2477 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '525'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2477 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '625'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=659 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '207'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=659 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '208'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=659 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '307'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=659 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '308'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=659 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '408'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=659 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '507'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=659 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '508'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=659 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '607'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=659 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '608'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=659 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '707'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=659 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '708'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '217'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '907'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1007'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1107'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1207'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1307'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1407'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1507'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1607'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1707'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1807'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1907'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2007'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2107'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2207'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2307'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2407'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2507'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2607'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2707'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2807'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2907'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3007'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3107'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1179 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3207'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1034 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '233'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '729'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '812'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '919'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1019'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1119'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1219'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1319'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1419'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1519'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1619'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2744 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '802+803'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '724'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '807'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '914'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1014'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1114'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1214'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1314'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1414'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1514'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1614'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '236'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '336'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '436'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '536'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '636'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '732'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '815'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '922'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1022'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1122'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1222'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1322'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1422'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1522'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1403 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1622'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=906 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '201'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=906 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '301'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=906 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '401'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=906 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '501'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=906 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '601'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=906 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '701'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=965 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '223'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=965 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '323'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=965 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '423'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=965 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '523'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=965 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '623'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1472 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '213'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1472 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '313'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1472 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '413'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1472 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '513'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1472 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '613'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1472 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '713'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=906 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '204'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=906 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '304'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=906 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '404'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=906 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '504'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=906 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '604'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=906 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '704'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2958 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '902'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1002'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1102'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1202'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1302'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1402'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1502'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1602'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1702'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1802'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1902'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2002'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2102'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2202'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2302'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2402'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2502'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2602'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2702'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2802'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2902'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3002'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3102'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2912 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3202'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '903'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1003'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1103'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1203'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1303'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1403'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1503'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1603'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1703'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1803'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1903'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2003'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2103'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2203'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2303'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2403'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2503'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2603'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2703'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2803'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2903'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3003'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3103'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=928 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3203'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1237 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '224'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1237 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '324'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1237 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '424'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1237 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '524'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1237 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '624'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid= where col_Phase = '' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = 'Main - 2AG.6014'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '216'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '316'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '416'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '516'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '616'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '716'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '801'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '906'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1006'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1106'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1206'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1306'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1406'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1506'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1606'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1706'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1806'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1906'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2006'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2106'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2206'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2306'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2406'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2506'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2606'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2706'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2806'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2906'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3006'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3106'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=974 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3206'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '232'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '332'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '432'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '532'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '632'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '728'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '811'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '918'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1018'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1118'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1218'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1318'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1418'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1518'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1043 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1618'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=950 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '222'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=950 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '322'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=950 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '422'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=950 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '522'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=950 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '622'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=950 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '722'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=950 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '912'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1012'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1112'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1212'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1312'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1412'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1512'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1612'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1712'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1812'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1912'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2012'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2112'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2212'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2312'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2412'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2512'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2612'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2712'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2812'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2912'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3012'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3112'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=954 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3212'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '215'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '315'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '415'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '515'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '615'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '715'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '905'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1005'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1105'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1205'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1305'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1405'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1505'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1605'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1705'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1805'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1905'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2005'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2105'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2205'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2305'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2405'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2505'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2605'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2705'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2805'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2905'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3005'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3105'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1298 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3205'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '231'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '331'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '431'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '531'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '631'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '727'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '810'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '917'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1017'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1117'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1217'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1317'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1417'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1517'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1509 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1617'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3008 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '205'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3008 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '305'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3008 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '405'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3008 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '505'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3008 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '605'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3008 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '705'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '210'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '211'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '212'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '310'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '311'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '312'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '410'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '411'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '412'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '510'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '511'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '512'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '610'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '611'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '612'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '710'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '711'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2163 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '712'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1275 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '226'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2254 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '227'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2957 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '326'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2254 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '327'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2957 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '426'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2254 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '427'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2957 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '526'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2254 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '527'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2957 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '626'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2254 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '627'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2048 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '317'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2048 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '417'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2048 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '517'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2048 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '617'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2048 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '717'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2218 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '333'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2218 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '433'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2218 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '533'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2218 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '633'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '321'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '421'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '521'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '621'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '721'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '911'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1011'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1111'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1211'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1311'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1411'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1511'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1611'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1711'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1811'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1911'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2011'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2111'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2211'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2311'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2411'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2511'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2611'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2711'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2811'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2911'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3011'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3111'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3037 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3211'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '237'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '337'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '437'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '537'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '637'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '733'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '816'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '923'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1023'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1123'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1223'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1323'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1423'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1523'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3306 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1623'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=987 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '228'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=987 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '328'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=987 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '428'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=987 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '528'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=987 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '628'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1678 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '218'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1157 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '318'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1157 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '418'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1157 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '518'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1157 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '618'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1157 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '718'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '908'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1008'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1108'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1208'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1308'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1408'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1508'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1608'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1708'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1808'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1908'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2008'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2108'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2208'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2308'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2408'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2508'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2608'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2708'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2808'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2908'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3008'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3108'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1925 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3208'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=659 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '407'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1496 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '234'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=915 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '334'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=915 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '434'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=915 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '534'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=915 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '634'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1442 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '730'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1442 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '813'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1442 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1020'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1442 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1120'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1442 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1220'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1442 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1320'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1442 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1420'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1442 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1520'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1442 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1620'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2562 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '920+921'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid= where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = 'TH 01'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid= where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = 'TH 02'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid= where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = 'TH 03'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid= where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = 'TH 04'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid= where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = 'TH 05'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid= where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = 'TH 06'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid= where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = 'TH 07'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid= where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = 'TH 08'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1408 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '202'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1408 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '203'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1475 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '302'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1475 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '303'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1475 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '402'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1475 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '403'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1475 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '502'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1475 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '503'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1475 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '602'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1475 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '603'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1475 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '702'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=1475 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '703'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3197 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '214'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3197 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '314'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3197 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '414'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3197 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '514'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3197 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '614'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3197 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '714'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '904'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1004'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1104'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1204'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1304'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1404'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1504'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1604'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1704'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1804'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1904'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2004'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2104'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2204'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2304'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2404'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2504'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2604'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2704'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2804'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '2904'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3004'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3104'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=3075 where col_Phase = 'B2 North' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '3204'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2829 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '726'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2829 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '809'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2829 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '916'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2829 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1016'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2829 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1116'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2829 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1216'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2829 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1316'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2829 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1416'; update tb_InvoiceItem set col_Measurement='na', col_Upgradeid=2829 where col_Phase = 'D South' and col_Description like 'A La Carte: Window Coverings%' and col_Lot = '1516'; update tb_InvoiceItem set col_AccountName ='Extra' where col_Description = 'Package - UPG Light'; update tb_InvoiceItem set col_AccountName ='Extra' where col_Description = 'Package - PRM Light'; update tb_InvoiceItem set col_AccountName ='Extra' where col_Description = 'Package - PRM Dark'; update tb_InvoiceItem set col_AccountName ='Extra' where col_Description = 'A La Carte: Window Coverings - UPG - Roller Shades - White Colour'; update tb_InvoiceItem set col_AccountName ='Extra' where col_Description = 'A La Carte: Window Coverings - UPG - Roller Shades - Linen Colour'; update tb_InvoiceItem set col_AccountName ='Extra' where col_Description = 'A La Carte: Under-Cabinet Lighting - UPG - Add Under-Cabinet Lighting'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Flooring - PRM Light - Coconut Chai'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Flooring - PRM Dark - Spiked Ice'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Flooring - UPG Light - Coconut Chai'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Flooring - UPG Dark - Spiked Ice'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'A La Carte: Under-Cabinet Lighting - UPG - Add Under-Cabinet Lighting'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'A La Carte: Window Coverings - UPG - Roller Shades - Linen Colour'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'A La Carte: Window Coverings - UPG - Roller Shades - White Colour'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Ensuite Bathroom: Cabinets - PRM Dark - Metallic Elm EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Ensuite Bathroom: Cabinets - PRM Light - Milano Walnut EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Ensuite Bathroom: Cabinets - UPG Light - Milano Walnut EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like '??Ensuite Bathroom: Counter - Dark - Solid S04 Steel'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like '??Ensuite Bathroom: Counter - Light - Solid S09 White'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Ensuite Bathroom: Floor Tiles - PRM Dark - Blue Paver Honed - 12" x 24"'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Ensuite Bathroom: Floor Tiles - PRM Light - Bottochino Honed - 12" x 24"'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Ensuite Bathroom: Floor Tiles - UPG Light - Crema Luna Honed 12” x 24”'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Ensuite Bathroom: Wall Tiles - PRM - Dolomite White Polished - 12" x 24"'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Ensuite Bathroom: Wall Tiles - UPG - Oriental White Polished 12” x 24”'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Backsplash - PRM Dark - Black Mist Polished'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Backsplash - PRM Light - White Alamo Polished'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Backsplash - UPG Light - White Gloss - 4.8 x 30 cm'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Cabinets - PRM Dark - Metallic Elm EuroGloss/Storm Grey EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Cabinets - PRM Light - Milano Walnut EuroGloss/White EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Cabinets - UPG Light - Milano Walnut EuroGloss/White EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Counter - Dark - Black Mist Polished'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Counter - Light - White Alamo Polished'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Flooring - PRM Dark - Spiked Ice'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Flooring - PRM Light - Coconut Chai'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Kitchen: Flooring - UPG Light - Coconut Chai'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bath: Cabinets - PRM Dark - Metallic Elm EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bath: Cabinets - PRM Light - White EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bath: Cabinets - UPG Light - White EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bath: Medicine Cabinet - PRM Dark - Storm Grey EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bath: Medicine Cabinet - PRM Light - White EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bath: Medicine Cabinet - UPG Light - White EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bathroom: Cabinets - PRM Dark - Metallic Elm EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bathroom: Cabinets - PRM Light - White EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bathroom: Cabinets - UPG Light - White EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like '??Main Bathroom: Counter - Solid S09 White'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bathroom: Floor Tiles - PRM Dark - Grigio Carnico Honed - 12" x 24"'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bathroom: Floor Tiles - PRM Light - Oriental White Polished'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bathroom: Floor Tiles - UPG Light - Silver Matte - 12" x 24"'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bathroom: Medicine Cabinet - PRM Dark - Storm Grey EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bathroom: Medicine Cabinet - PRM Light - White EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bathroom: Medicine Cabinet - UPG Light - White EuroGloss'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bathroom: Wall Tiles - PRM - Dolomite White Polished - 12" x 24"'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Main Bathroom: Wall Tiles - UPG - Superbianco Polished'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Package - PRM Dark'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Package - PRM Light'; update tb_InvoiceItem set col_AccountName = 'Extra' where col_Description like 'Package - UPG Light';