>
>try with a macro
>
>in (&vp_isalesdocid)
>
>
>
>Thank you Fabio for your suggestion but the backend SQL Server doesn't understand the macro substitution syntax & so this doesn't work.
>I don't really know why VFP only takes into account the first value in the IN( x,y,z) clause so I think I'll settle for a SQL Pass Through approach because this does work.
>
>BTW: I also tested manually creating the remote view but this gives me the same result as the VFP9 View designer.
>
>Mark

It works for me.

PUBLIC inItems
inItems = '1,2'
CREATE SQL VIEW TEST REMOTE AS SELECT * FROM TABLE WHERE id IN (&inItems) CONNECTION ....
USE TEST