title: TRY_CAST is not a recognized built-in function name
body: <p>I have a puzzle with regards to the behavior of the SQL Server Management Studio.
  I am connected to a SQL Server database - version: </p>
  
  <pre><code>Microsoft SQL Server 2014 (SP1-CU3) (KB3094221) - 12.0.4427.24 (X64) 
      Oct 10 2015 17:18:26 
      Copyright (c) Microsoft Corporation
      Enterprise Edition (64-bit) on Windows NT 6.3 &lt;X64&gt; (Build 9600: ) (Hypervisor)
  </code></pre>
  
  <p>When I run the following query from management studio, it returns me the correct output.</p>
  
  <pre><code>SELECT TRY_CAST('ax' AS decimal)
  
  SELECT TRY_CAST('4.0' as decimal)
  </code></pre>
  
  <p>However the built-in editor gives me a message saying this function is not recognized.</p>
  
  <p><a href="https://i.stack.imgur.com/o7jAz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/o7jAz.png" alt="Built-In Function"></a></p>
  
  <p>Edited to Add: Sql Server Management Studio version.
  <a href="https://i.stack.imgur.com/ih0GM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ih0GM.png" alt="SQL Server Management Studio 2014"></a></p>