>Hey all
>
>I know in VFP I can refer to a field name via a variable name as MyTable..&VarField.
>
>Is it possible to do something similar in SQL?
>
>thanks

In SQL Server you will need to use dynamic SQL - construct the command as a string and execute it using

execute sp_executesql @SQL

stored procedure passing parameters if needed.