The perform returns the initial and very last name of a provided BusinessEntityID along with the contact kind for that particular person. The CASE expression within the SET assertion establishes the worth to Display screen to the column ContactType dependant on the existence on the BusinessEntityID column in the worker, https://edwinpdbpk.onesmablog.com/everything-about-ivey-case-solutions-76640312