SELECT * FROM table_name WHERE (VarFieldName) = VarFieldTextSome may suggest macro substitution, &VarFieldName, but name expressions are faster.
SELECT * FROM table_name WHERE ('table_name.' + VarFieldName) = VarFieldTextBe sure to include the period after the table name in quotes.