>>>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.

One other question, now that I have you on the line: Can I create a SP in SQL from VFP with SQLEXEC()?

I tried something like this:

TEXT TO lcQuery TEXTMERGE NOSHOW
ALTER PROCEDURE [dbo].[UserHasAccess]
	@tnCoID int = 0, 
	@tcUsKey varchar(36) = ''
AS
BEGIN
	SET NOCOUNT ON;
	DECLARE @lcSQL nvarchar(max)
	SET @lcSQL  = 'select CAST(COUNT(*) AS int) AS FXCount from ' + 'Payroll' + ltrim(str(@tnCoId)) + '..Roles' + ' where DelFlag = 0 AND roUsKey = @tcUsKey'
	EXECUTE sp_ExecuteSQL @lcSQL, N'@tcUsKey varchar(36)', @tcUsKey
END TRANSACTION
ENDTEXT

SQLEXEC(nConn,lcQuery)