title: Passing comma-separated value from .NET to stored procedure using the value in "IN" SQL function
body: <p>I have an SQL query similar to the following:</p>
  
  <pre><code>create procedure test
  (
     @param1 nvarchar(max)
  )
  as
  begin
      select * from table where column1 in (@param1)
  end
  </code></pre>
  
  <p>Now I need to pass the value of <code>@param1</code> from my .net application in such a way that the above query works.</p>
  
  <p>Can some one please advise me on how to pass from my VB.NET code a value which is similiar to below:</p>
  
  <p><code>'1','2','3'</code></p>
  
  <p>My main question is how do I structure value of parameter like above example from my .NET application?</p>