title: <table-valued function> is not a recognized built-in function name
body: <p>I am getting this error:</p>
  
  <blockquote>
    <p>Msg 195, Level 15, State 10, Line 1<br>
    'fnParseName' is not a recognized built-in function name.</p>
  </blockquote>
  
  <p>On this query:</p>
  
  <pre><code>SELECT  fnParseName(DOCTORFIRSTNAME+' ' +DOCTORLASTNAME) 
    FROM [PracticeandPhysician]
  </code></pre>
  
  <p>Here's the code for fnParseName</p>
  
  <pre><code>create FUNCTION [dbo].[fnParseName]
                 (@FullName NVARCHAR(128))
  RETURNS @FullNameParts TABLE  (FirstName  NVARCHAR(128),
                                 Middle     NVARCHAR(128),
                                 LastName   NVARCHAR(128))
  AS
    BEGIN
      ... function body that populates @FullNameParts ...
      RETURN
    END
  </code></pre>
  
  <p>Why am I getting this error?</p>