title: VARCHAR' is not a recognized built-in function name
body: <p>Here is my mssql function code. </p>
  
  <pre><code> ALTER function [dbo].[UF_GetOrderProducts]
  (
    @OrderId int
  )
  returns varchar(500)
  as
  begin
  
  return
    (
    select CAST(VARCHAR(5),OP.ProductId)+'&lt;br/&gt;'
    from OrderProduct as OP
  
    where OP.OrderId = @OrderId
    for xml path(''), type
    ).value('.', 'varchar(500)')
  end
  </code></pre>
  
  <p>It returns, <code>VARCHAR' is not a recognized built-in function name.</code></p>