title: using a case statement inside a string
body: <p>I need to put a case statement in a string. How can this be achieved?</p>
  
  <pre><code>select DATEDIFF(MM, select CASE FA.new_ownertype
          WHEN 8 then FA.new_vlenrollmentstartdate
          ELSE FA.new_contractstartdate from BingMapsPlatform_Stagging.dbo.FilteredAccount as FA
          END, GETDATE())
  </code></pre>