RE: Remote View Inlist Parameterized where clause

Author: Dan Neuman

Posted: 2002-11-08 at 09:19:15

Thanks for all your input on this.

I received the answer from the VFE forum.

Another developer had the idea of using the CHARINDEX function in the Where

clause. Since my parameter field is a one character field, it works like I

need it.

Here is the solution.

Something like:

Local vp_List

vp_List = [A,B,C,] && must end with a comma

Use RemoteViewName

Remote View SQL Statement:

Select Table.*

from dbo.Tablename

where charindex( rtrim(TableName.FieldName)+',',?vp_list) > 0

©2002 Dan Neuman