I want to write a select statement where I can use a variable to store the table name, then use that variable in my select statement. For example:

Instead of:
Select * from Mytable

I want to:
Set @SomeTableName = 'Mytable'
Select * from @SomeTableName

but, I can't get it to work. Can you tell me how I should approach this problem.