>>thisfield = 'current.sc1_2000' >> >>SELECT st_name, Current.* ; >>FROM tipdatabase!tip T ; >>INNER JOIN tipdatabase!current ; >>ON t.tip_id = current.tip_id ; >>WHERE ALLTRIM(eval(thisfield)) = "STP" >>>>
>SELECT st_name, Current.* ; >>FROM tipdatabase!tip T ; >>INNER JOIN tipdatabase!current ; >>ON t.tip_id = current.tip_id ; >>WHERE alltrim(&thisField) = "STP"Ah HA! Thanks Naomi.