In Stored procedure I would like to use local variable as a Table Name in a Select Query

For Example :
Declare @ MyTable
Select @MyTable = "MASTER1"
Select * from @MyTable

In Orcale there is a function name_in() which resolves the variable to a string.

Is there any functionality available or not in SQL Server 6.5

Awaiting for Immediate Reply.
ThanK You
Yours

ANCHAL VERMA
Corporate MIS