>You can use dynamic sql
DECLARE @sql nvarchar(4000)
>SET @sql = 'SELECT * FROM ' + @Table + 'WHERE ...'
>EXECUTE (@sql)
>
Sergey,
I was wondering, from your experience, is there much gain in speed if you put the dynamic SQL in a stored procedure, versus, sending this SQL statement to SQL Server through SPT (VFP)?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham