I have a question for the SQL Server remote view gurus.

I need to create a remote view to a SQL database, and in the where clause I

would like to provide a list of values. And if the field matches one of

those values, then return the record.

Is there a way to do that?

Something like:

Local vp_List

vp_List = ["A","B","C"]

Use RemoteViewName

Remote View SQL Statement:

Select Table.* from dbo.Tablename where inlist(Tablename.Field, ?vp_List)