You can use dynamic SQL to do what you want. Try this

USE pubs
DECLARE @tablename varchar(30)
SELECT @tablename = 'authors'
EXECUTE ('SELECT * FROM ' + @tablename)


-Mike