There's no such thing in SQL Server but you can use EXECUTE command or sp_executesql system stored procedure to execute a Transact-SQL statement or batch build as a string. See BOL for details.

>Hi all,
>
>Does anyone know a similar SQL syntax to VFP's & command that performs macro substitution?
>
>Thank you ,
>Daniel