====== Contacts ======

===== Delete Phone Number =====
This query deletes a specified phone number from all records in the contact table.
<code sql>
BEGIN TRANSACTION
UPDATE Contact
SET 
homePhone = CASE WHEN homePhone = '(555)555-5555' THEN null ELSE homePhone END,
workPhone = CASE WHEN workPhone = '(555)555-5555' THEN null ELSE workPhone END,
cellPhone = CASE WHEN cellPhone = '(555)555-5555' THEN null ELSE cellPhone END
WHERE homePhone = '(555)555-5555' OR workPhone = '(555)555-5555' OR  cellPhone = '(555)555-5555'
ROLLBACK TRANSACTION
--COMMIT TRANSACTION
</code>