title: Arrays in UserDefinedFunctions?
body: <p>I created a User Defined Function with VB.NET and want to use that function in SQLServer. Everything seems to work fine. </p>
  
  <p>Now I want to use an array as parameter. Is it possible?</p>
  
  <p>Example of my test method (without parameters):</p>
  
  <pre><code>Partial Public Class UserDefinedFunctions
      &lt;Microsoft.SqlServer.Server.SqlFunction()&gt; _
      Public Shared Function TestFunction() As SqlString
          ' Add your code here
          Return New SqlString("Hello World")
      End Function
  End Class
  </code></pre>
  
  <p>Can someone give me a working example or some ideas for a workaround?</p>
  
  <p>Thanx</p>