insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : OLD CRN to : New CRN and added CRQ : CRQ" from catalogCRG where CRN like "OLD CRN" 
 update catalogcrg set crq = "newcrq" where crn="old CRN" 
 update catalogcrg set crn="New CRN" where CRN="OLD CRN"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : MANTEGNA, ANDREA, AFTER to : Mantegna, Andrea and added CRQ : after" from catalogCRG where CRN like "MANTEGNA, ANDREA, AFTER" 
 update catalogcrg set crq = "after" where crn="MANTEGNA, ANDREA, AFTER" 
 update catalogcrg set crn="Mantegna, Andrea" where CRN="MANTEGNA, ANDREA, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : MARE, ANDRE, AFTER to : Mare, Andre and added CRQ : after" from catalogCRG where CRN like "MARE, ANDRE, AFTER" 
 update catalogcrg set crq = "after" where crn="MARE, ANDRE, AFTER" 
 update catalogcrg set crn="Mare, Andre" where CRN="MARE, ANDRE, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : MAYER, MARIE FRANCISE CONSTANCE LA MARTINIERE, AFTER to : Mayer, Marie Fracise Constance la Martinier and added CRQ : after" from catalogCRG where CRN like "MAYER, MARIE FRANCISE CONSTANCE LA MARTINIERE, AFTER" 
 update catalogcrg set crq = "after" where crn="MAYER, MARIE FRANCISE CONSTANCE LA MARTINIERE, AFTER" 
 update catalogcrg set crn="Mayer, Marie Fracise Constance la Martinier" where CRN="MAYER, MARIE FRANCISE CONSTANCE LA MARTINIERE, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : MURILLO, BARTOLOME ESTEBAN, AFTER to : Murillo, Bartolome Esteban and added CRQ : after" from catalogCRG where CRN like "MURILLO, BARTOLOME ESTEBAN, AFTER" 
 update catalogcrg set crq = "after" where crn="MURILLO, BARTOLOME ESTEBAN, AFTER" 
 update catalogcrg set crn="Murillo, Bartolome Esteban" where CRN="MURILLO, BARTOLOME ESTEBAN, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : MUSI, AGOSTINO, AFTER to : Musi, Agostino and added CRQ : after" from catalogCRG where CRN like "MUSI, AGOSTINO, AFTER" 
 update catalogcrg set crq = "after" where crn="MUSI, AGOSTINO, AFTER" 
 update catalogcrg set crn="Musi, Agostino" where CRN="MUSI, AGOSTINO, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : Master I.B., After to : Master I.B. and added CRQ : after" from catalogCRG where CRN like "Master I.B., After" 
 update catalogcrg set crq = "after" where crn="Master I.B., After" 
 update catalogcrg set crn="Master I.B." where CRN="Master I.B., After"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : Master of the Brussels Initials and Associates to : Master of the Brussels Initials and added CRQ : and Associates" from catalogCRG where CRN like "Master of the Brussels Initials and Associates" 
 update catalogcrg set crq = "and Associates" where crn="Master of the Brussels Initials and Associates" 
 update catalogcrg set crn="Master of the Brussels Initials" where CRN="Master of the Brussels Initials and Associates"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : Muzaffar-Ali (attributed to) to : Muzaffar-Ali and added CRQ : attributed to" from catalogCRG where CRN like "Muzaffar-Ali (attributed to)" 
 update catalogcrg set crq = "attributed to" where crn="Muzaffar-Ali (attributed to)" 
 update catalogcrg set crn="Muzaffar-Ali" where CRN="Muzaffar-Ali (attributed to)"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : NEWTON, GILBERT STUART NEWTON, AFTER to : Newton, Gilbert Stuart and added CRQ : after" from catalogCRG where CRN like "NEWTON, GILBERT STUART NEWTON, AFTER" 
 update catalogcrg set crq = "after" where crn="NEWTON, GILBERT STUART NEWTON, AFTER" 
 update catalogcrg set crn="Newton, Gilbert Stuart" where CRN="NEWTON, GILBERT STUART NEWTON, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : Nainsukh, Family of to : Nainsukh and added CRQ : family of" from catalogCRG where CRN like "Nainsukh, Family of" 
 update catalogcrg set crq = "family of" where crn="Nainsukh, Family of" 
 update catalogcrg set crn="Nainsukh" where CRN="Nainsukh, Family of"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : New England Glass Company? to : New England Glass Co. and added CRQ : ?" from catalogCRG where CRN like "New England Glass Company?" 
 update catalogcrg set crq = "?" where crn="New England Glass Company?" 
 update catalogcrg set crn="New England Glass Co." where CRN="New England Glass Company?"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : Ostade, Adriaen van, After to : Ostade, Adriaen van and added CRQ : after" from catalogCRG where CRN like "Ostade, Adriaen van, After" 
 update catalogcrg set crq = "after" where crn="Ostade, Adriaen van, After" 
 update catalogcrg set crn="Ostade, Adriaen van" where CRN="Ostade, Adriaen van, After"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : PALMER, F., AFTER to : Palmer, F. and added CRQ : after" from catalogCRG where CRN like "PALMER, F., AFTER" 
 update catalogcrg set crq = "after" where crn="PALMER, F., AFTER" 
 update catalogcrg set crn="Palmer, F." where CRN="PALMER, F., AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : PITKIN GLASSWORKS, POSSIBLY. NEW ENGLAND to : Pitkin Glassworks and added CRQ : possibly" from catalogCRG where CRN like "PITKIN GLASSWORKS, POSSIBLY. NEW ENGLAND" 
 update catalogcrg set crq = "possibly" where crn="PITKIN GLASSWORKS, POSSIBLY. NEW ENGLAND" 
 update catalogcrg set crn="Pitkin Glassworks" where CRN="PITKIN GLASSWORKS, POSSIBLY. NEW ENGLAND"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : POUSSIN, NICOLAS AFTER to : Pousin, Nicolas and added CRQ : after" from catalogCRG where CRN like "POUSSIN, NICOLAS AFTER" 
 update catalogcrg set crq = "after" where crn="POUSSIN, NICOLAS AFTER" 
 update catalogcrg set crn="Pousin, Nicolas" where CRN="POUSSIN, NICOLAS AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : PRUDHON, PIERRE PAUL, AFTER to : Prudhon, Pierre Paul and added CRQ : after" from catalogCRG where CRN like "PRUDHON, PIERRE PAUL, AFTER" 
 update catalogcrg set crq = "after" where crn="PRUDHON, PIERRE PAUL, AFTER" 
 update catalogcrg set crn="Prudhon, Pierre Paul" where CRN="PRUDHON, PIERRE PAUL, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : Pyne, Marked by Benjamin to : Pyne, Benjamin and added CRQ : marked by" from catalogCRG where CRN like "Pyne, Marked by Benjamin" 
 update catalogcrg set crq = "marked by" where crn="Pyne, Marked by Benjamin" 
 update catalogcrg set crn="Pyne, Benjamin" where CRN="Pyne, Marked by Benjamin"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : RAPHAEL, AFTER to : Raphael and added CRQ : after" from catalogCRG where CRN like "RAPHAEL, AFTER" 
 update catalogcrg set crq = "after" where crn="RAPHAEL, AFTER" 
 update catalogcrg set crn="Raphael" where CRN="RAPHAEL, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : RELLAM?, D. to : Rellan, D. and added CRQ : ?" from catalogCRG where CRN like "RELLAM?, D." 
 update catalogcrg set crq = "?" where crn="RELLAM?, D." 
 update catalogcrg set crn="Rellan, D." where CRN="RELLAM?, D."
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : REMBRANDT HARMENSZ. VAN RIJN AFTER to : Rembrandt Harmensz van Rijn and added CRQ : after" from catalogCRG where CRN like "REMBRANDT HARMENSZ. VAN RIJN AFTER" 
 update catalogcrg set crq = "after" where crn="REMBRANDT HARMENSZ. VAN RIJN AFTER" 
 update catalogcrg set crn="Rembrandt Harmensz van Rijn" where CRN="REMBRANDT HARMENSZ. VAN RIJN AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : REYNOLDS, JOSHUA AFTER to : Reynolds, Joshua and added CRQ : after" from catalogCRG where CRN like "REYNOLDS, JOSHUA AFTER" 
 update catalogcrg set crq = "after" where crn="REYNOLDS, JOSHUA AFTER" 
 update catalogcrg set crn="Reynolds, Joshua" where CRN="REYNOLDS, JOSHUA AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : RIGAUD, HYACINTHE, AFTER to : Rigaud, Hyacinthe and added CRQ : after" from catalogCRG where CRN like "RIGAUD, HYACINTHE, AFTER" 
 update catalogcrg set crq = "after" where crn="RIGAUD, HYACINTHE, AFTER" 
 update catalogcrg set crn="Rigaud, Hyacinthe" where CRN="RIGAUD, HYACINTHE, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : RUBENS, PETER PAUL, AFTER to : Rubens, Peter Paul and added CRQ : after" from catalogCRG where CRN like "RUBENS, PETER PAUL, AFTER" 
 update catalogcrg set crq = "after" where crn="RUBENS, PETER PAUL, AFTER" 
 update catalogcrg set crn="Rubens, Peter Paul" where CRN="RUBENS, PETER PAUL, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : SCHONGAUER, MARTIN, AFTER to : Schongauer, Martin and added CRQ : after" from catalogCRG where CRN like "SCHONGAUER, MARTIN, AFTER" 
 update catalogcrg set crq = "after" where crn="SCHONGAUER, MARTIN, AFTER" 
 update catalogcrg set crn="Schongauer, Martin" where CRN="SCHONGAUER, MARTIN, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : SIMONAU, PIERRE, AFTER to : Simonau, Pierre and added CRQ : after" from catalogCRG where CRN like "SIMONAU, PIERRE, AFTER" 
 update catalogcrg set crq = "after" where crn="SIMONAU, PIERRE, AFTER" 
 update catalogcrg set crn="Simonau, Pierre" where CRN="SIMONAU, PIERRE, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : SNELL, HENRY BAYLEY, AFTER to : Snell, Henry Bayley and added CRQ : after" from catalogCRG where CRN like "SNELL, HENRY BAYLEY, AFTER" 
 update catalogcrg set crq = "after" where crn="SNELL, HENRY BAYLEY, AFTER" 
 update catalogcrg set crn="Snell, Henry Bayley" where CRN="SNELL, HENRY BAYLEY, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : SPRANGER, BARTHOLOMEUS AFTER to : Spranger, Bartholomeus and added CRQ : after" from catalogCRG where CRN like "SPRANGER, BARTHOLOMEUS AFTER" 
 update catalogcrg set crq = "after" where crn="SPRANGER, BARTHOLOMEUS AFTER" 
 update catalogcrg set crn="Spranger, Bartholomeus" where CRN="SPRANGER, BARTHOLOMEUS AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : STERNER, ALBERT EDWARD, AFTER to : Sterner, Albert Edward and added CRQ : after" from catalogCRG where CRN like "STERNER, ALBERT EDWARD, AFTER" 
 update catalogcrg set crq = "after" where crn="STERNER, ALBERT EDWARD, AFTER" 
 update catalogcrg set crn="Sterner, Albert Edward" where CRN="STERNER, ALBERT EDWARD, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : STUBBS, GEORGE, AFTER to : Stubbs, George and added CRQ : after" from catalogCRG where CRN like "STUBBS, GEORGE, AFTER" 
 update catalogcrg set crq = "after" where crn="STUBBS, GEORGE, AFTER" 
 update catalogcrg set crn="Stubbs, George" where CRN="STUBBS, GEORGE, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : STULL, HENRY, AFTER to : Stull, Henry and added CRQ : after" from catalogCRG where CRN like "STULL, HENRY, AFTER" 
 update catalogcrg set crq = "after" where crn="STULL, HENRY, AFTER" 
 update catalogcrg set crn="Stull, Henry" where CRN="STULL, HENRY, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : SUE, LOUIS, AFTER to : Sue, Louis and added CRQ : after" from catalogCRG where CRN like "SUE, LOUIS, AFTER" 
 update catalogcrg set crq = "after" where crn="SUE, LOUIS, AFTER" 
 update catalogcrg set crn="Sue, Louis" where CRN="SUE, LOUIS, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : SWETT, MOSES, AFTER to : Swett, Moses and added CRQ : after" from catalogCRG where CRN like "SWETT, MOSES, AFTER" 
 update catalogcrg set crq = "after" where crn="SWETT, MOSES, AFTER" 
 update catalogcrg set crn="Swett, Moses" where CRN="SWETT, MOSES, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : School of Redon to : Redon, Odilon and added CRQ : School of" from catalogCRG where CRN like "School of Redon" 
 update catalogcrg set crq = "School of" where crn="School of Redon" 
 update catalogcrg set crn="Redon, Odilon" where CRN="School of Redon"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : School of Antoine Charles Horace Vernet to : Vernet, Antoine Charles Horace and added CRQ : School of" from catalogCRG where CRN like "School of Antoine Charles Horace Vernet" 
 update catalogcrg set crq = "School of" where crn="School of Antoine Charles Horace Vernet" 
 update catalogcrg set crn="Vernet, Antoine Charles Horace" where CRN="School of Antoine Charles Horace Vernet"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : TROYE, EDWARD, AFTER to : Troye, Edward and added CRQ : after" from catalogCRG where CRN like "TROYE, EDWARD, AFTER" 
 update catalogcrg set crq = "after" where crn="TROYE, EDWARD, AFTER" 
 update catalogcrg set crn="Troye, Edward" where CRN="TROYE, EDWARD, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : VERNET, CARLE, After to : Vernet, Carle and added CRQ : after" from catalogCRG where CRN like "VERNET, CARLE, After" 
 update catalogcrg set crq = "after" where crn="VERNET, CARLE, After" 
 update catalogcrg set crn="Vernet, Carle" where CRN="VERNET, CARLE, After"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : VERNIER, CHARLES, AFTER to : Vernier, Charles and added CRQ : after" from catalogCRG where CRN like "VERNIER, CHARLES, AFTER" 
 update catalogcrg set crq = "after" where crn="VERNIER, CHARLES, AFTER" 
 update catalogcrg set crn="Vernier, Charles" where CRN="VERNIER, CHARLES, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : VOSS, FRANKLIN BROOKE, AFTER to : Voss, Franklin Brooke and added CRQ : after" from catalogCRG where CRN like "VOSS, FRANKLIN BROOKE, AFTER" 
 update catalogcrg set crq = "after" where crn="VOSS, FRANKLIN BROOKE, AFTER" 
 update catalogcrg set crn="Voss, Franklin Brooke" where CRN="VOSS, FRANKLIN BROOKE, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : Vandermeul, After to : Vandermeul and added CRQ : after" from catalogCRG where CRN like "Vandermeul, After" 
 update catalogcrg set crq = "after" where crn="Vandermeul, After" 
 update catalogcrg set crn="Vandermeul" where CRN="Vandermeul, After"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : WALTON, H., AFTER to : Walton, H. and added CRQ : after" from catalogCRG where CRN like "WALTON, H., AFTER" 
 update catalogcrg set crq = "after" where crn="WALTON, H., AFTER" 
 update catalogcrg set crn="Walton, H." where CRN="WALTON, H., AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : WEBER, THOMAS, AFTER to : Weber, Thomas and added CRQ : after" from catalogCRG where CRN like "WEBER, THOMAS, AFTER" 
 update catalogcrg set crq = "after" where crn="WEBER, THOMAS, AFTER" 
 update catalogcrg set crn="Weber, Thomas" where CRN="WEBER, THOMAS, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : WILES, IRVING RAMSEY, AFTER to : Wiles, Irving Ramsey and added CRQ : after" from catalogCRG where CRN like "WILES, IRVING RAMSEY, AFTER" 
 update catalogcrg set crq = "after" where crn="WILES, IRVING RAMSEY, AFTER" 
 update catalogcrg set crn="Wiles, Irving Ramsey" where CRN="WILES, IRVING RAMSEY, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : WILSON, AFTER to : Wilson and added CRQ : after" from catalogCRG where CRN like "WILSON, AFTER" 
 update catalogcrg set crq = "after" where crn="WILSON, AFTER" 
 update catalogcrg set crn="Wilson" where CRN="WILSON, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : WINT, PETER DE, AFTER to : De Wint, Peter and added CRQ : after" from catalogCRG where CRN like "WINT, PETER DE, AFTER" 
 update catalogcrg set crq = "after" where crn="WINT, PETER DE, AFTER" 
 update catalogcrg set crn="De Wint, Peter" where CRN="WINT, PETER DE, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : WINTERHALTER, FRANZ XAVER, AFTER to : Winterhalter, Franz Xavier and added CRQ : after" from catalogCRG where CRN like "WINTERHALTER, FRANZ XAVER, AFTER" 
 update catalogcrg set crq = "after" where crn="WINTERHALTER, FRANZ XAVER, AFTER" 
 update catalogcrg set crn="Winterhalter, Franz Xavier" where CRN="WINTERHALTER, FRANZ XAVER, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : WITH, P. DE, AFTER to : Wit, Pieter de and added CRQ : after" from catalogCRG where CRN like "WITH, P. DE, AFTER" 
 update catalogcrg set crq = "after" where crn="WITH, P. DE, AFTER" 
 update catalogcrg set crn="Wit, Pieter de" where CRN="WITH, P. DE, AFTER"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : Whistler, James Abbott McNeill (attributed to) to : Whistler, James Abbott McNeill and added CRQ : attributed to" from catalogCRG where CRN like "Whistler, James Abbott McNeill (attributed to)" 
 update catalogcrg set crq = "attributed to" where crn="Whistler, James Abbott McNeill (attributed to)" 
 update catalogcrg set crn="Whistler, James Abbott McNeill" where CRN="Whistler, James Abbott McNeill (attributed to)"
go

insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : Workshop, Fontana to : Fontana Workshop and added CRQ : workshop of" from catalogCRG where CRN like "Workshop, Fontana" 
 update catalogcrg set crq = "workshop of" where crn="Workshop, Fontana" 
 update catalogcrg set crn="Fontana Workshop" where CRN="Workshop, Fontana"


insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : LE GEMPT, AFTER to : Le Gempt and added CRQ : After" from catalogCRG where CRN like "LE GEMPT, AFTER" 
 update catalogcrg set crq = "After" where crn="LE GEMPT, AFTER" 
 update catalogcrg set crn="Le Gempt" where CRN="LE GEMPT, AFTER"
 
 
 
 insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : LE GEMPT, AFTER to : Le Gempt and added CRQ : After" from catalogCRG where CRN like "LE GEMPT, AFTER" 
 update catalogcrg set crq = "After" where crn="LE GEMPT, AFTER" 
 update catalogcrg set crn="Le Gempt" where CRN="LE GEMPT, AFTER"
 
 insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : LE GEMPT, AFTER to : Le Gempt and added CRQ : After" from catalogCRG where CRN like "LE GEMPT, AFTER" 
 update catalogcrg set crq = "After" where crn="LE GEMPT, AFTER" 
 update catalogcrg set crn="Le Gempt" where CRN="LE GEMPT, AFTER"
 
 insert into catalogstatus (catalogid,status,ondate,ident,comment) select catalogid, 2, getdate(),'jtrant',"updated CRN value from : LE GEMPT, AFTER to : Le Gempt and added CRQ : After" from catalogCRG where CRN like "LE GEMPT, AFTER" 
 update catalogcrg set crq = "After" where crn="LE GEMPT, AFTER" 
 update catalogcrg set crn="Le Gempt" where CRN="LE GEMPT, AFTER"
 

DONE MANUALLY:
 
 BOSTON & SANDWICH GLASS CO., PROBABLY. MASSACHUSETTS
COVENTRY GLASS FACTORY CO., POSSIBLY. NEW ENGLAND
KEENE (MARLBORO STREET) GLASS WORKS, PROBABLY. NEW ENGLAND