>>In SQL Server you must use dynamic SQL for this purpose, e.g.
>>

>>declare @SQL nvarchar(max)
>>
>>set @SQL  = 'select * from ' + quotename(@TableName) + ' where UserName = @cUser'
>>
>>execute sp_ExecuteSQL @SQL, N'@cUser varchar(20)', @cUser

>
>Thanks, that looks really weird for a FoxPro guy, doesn't it? How did you ever get used to that?

I spent some time in MSDN T-SQL forum and for me now writing VFP SQL query takes a bit of a time - writing SQL queries comes naturally.