TE() THEN 0 ELSE 1 END StudentEnrollmentStatus,
s.number AS StudentSiteCode,
d.number AS StudentDistNum,
COALESCE(rm.[name], 'NHR') AS StudentHomeroom,
i4.lastnam...
CASE WHEN a.postOfficeBox = 1 THEN 'P.O. Box '+a.number
ELSE a.number+' '+COALESCE(a.prefix+' ','')+COALESCE(a.street+' ','')+COALESCE(a.tag+' ','')+COALESCE(a.d
====== Contacts ======
===== Delete Phone Number =====
This query deletes a specified phone number from all records in the contact table.
<code sql>
BEGIN