>>Can some one tell me why the WHERE clause in this select is being ignored? It pulls all the records.
>>
>>

>>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"
>>

>>
>>Thanks
>
>You can not use Eval here. You need to either use Macro substituon, or generate the whole select dynamically and still execute it using macro or execscript() function.
>
>So,
>

>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.