The OPENQUERY() doesn't support parameters. You can build whole query as a string and run with EXCEUTE statement.
>How do I use a parameter within an OPENQUERY
>
>THIS WORKS
>select * from openquery(VFP2,
>'
>select * from arcust
>)
>
>
>
>
>NOW I WANT TO INCOPORATE A PARAMETER - DOES NOT WORK
>
>declare @id varchar(10)
>select @id = "54440"
>
>select * from openquery(VFP2,
>'
>select * from arcust where ccustno=@id
>'
>)
>
>
--sb--