Update Address:
SELECT *
FROM dbo.addresses
WHERE address1 = '300 TOWNPARK DRIVE NW'
--begin tran t1
--UPDATE dbo.addresses
--SET
--address1 = '980 Cobb Pl Blvd NW',
--address2 = 'Ste 160'
--WHERE address1 = '300 TOWNPARK DRIVE NW';
--commit tran t1
--rollback tran t1
SELECT *
FROM dbo.addresses
WHERE address1 = '980 Cobb Pl Blvd NW'