How to select dynamic database name with prefix along with

Question

Hi team, How to select dynamic database name along with table name in sql server. E.g. I have one server there are multiple database with prefix elcm_ Elcm_mags Elcm _qadb Tec And table is common in all database Table name: tna.master Select *from elcm_orgnizationname.tna.master Now I want only change orgnizationname dynamically. E.g Select * from elcm_qadb.tna.master Select *from elcm_mags.tna.master. Pls give me solutions ASAP. THAnks & regards, Krunal Pande