/ select * from table1 where table1.name = (variable); / inputs. So how do I use a variable in place of table1.name. Wow. Let's try: you'll have to need a couple of variables. tblname="table" fldname="name" && these two filled by user before calling this: fullfld=alltrim(tblname)+'.'+alltrim(fldname) select * from (tblname) where (fullname) = (variable) BTW, maybe the TblName may need trimming the extra blanks.