MIME-Version: 1.0 Content-Location: file:///C:/A78792E5/phone_populate.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" ALTER VIEW dbo

 <= /o:p>

/*PURPOSE

Populate the Person table with phone number data. This uses the data that assembled in vw_HomePhoneNumber. If the phone number has fewer than five digits it is unusable, so ignore it.*/

 =

UPDATE person

SET <= span style=3D'font-size:9.0pt;font-family:"Courier New"'>homephonenumber =3D (SE= LECT rawhomephone from vw_HomePhoneNumber

WHERE person.person_id =3D vw_HomePhoneNumber.party_id and (len(vw_HomePhon= eNumber.rawhomephone) > 5))

WHERE EXISTS=

(SELECT * FROM vw_HomePhoneNumber)