====== 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'
RP2.personID1 AND RP2.guardianSeq = '2'
LEFT JOIN Contact C1 ON RP1.PersonID2 = C1.personID
LEFT JOIN Contact C2 ON RP2.PersonID2 = C2.personID
LEFT JOIN POSIdentif