dinamic sql problem

[victorashi]

i want to make a query in VS2005 wich allows me to dinamicaly imput a table and a column , something like :

select * from @a where @b='something'

can someone pls help me with the sintax?
thank you

 

[bborissov]

EXEC 'select * from '+@a+' where '+@b+'=''something'''

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.