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