Hi Robert,

I think it works only in SELECT statement to make the view parameters possible. Why do you need it in VFP at all? Your example works fine w/o '?' character.

x = 'ole biscuit'
z=99
s = "update wibble set ftang=x where pk=z"
&s

>When I use
>
>x = 'ole biscuit'
>z=99
>
>s = "update wibble set ftang=?x where pk=?z"
>
>in ODBC it works fine, but if I try this in VFP, via &s or as a direct statement, I get a syntax error. In SELECT it works correctly. Can I NOT do this in VFP but only in ODBC?
>
>Many thanks