Passing SQL IN parameters

How do I use numbers of values from multi-select dropdown components and use it in parameter for report viewer (perspective view) I want to use that selected multi values in basic query .Note : can select any number of values
select * from tablename where columnname IN ({Parameter}).

What SQL database engine are you using?

The heading is supposed to describe what your question is about. You don't write the whole question there. In your case this is "Passing SQL IN parameters to query". Then give the details in the post.

Use the </> button to format code such as Python and SQL.

1 Like

MS SQL i have used

Microsoft SQL has the STRING_SPLIT() function.

STRING_SPLIT (@Expression, ',').

I don't have MS SQL so I can't test it for you.

1 Like

Thanks, it worked for me