The function returns the 1st and past title of a specified BusinessEntityID along with the Get in touch with variety for that man or woman. The CASE expression while in the SET statement decides the worth to Screen with the column ContactType based upon the existence from the BusinessEntityID column https://pay-someome-to-take-case57354.jts-blog.com/34815302/facts-about-hbs-case-solution-revealed