Thanks Sergey -
With ANSI OFF, this produces 4 records (the correct answer).

SELECT st_name, Current.* ;
FROM tipdatabase!tip T ;
INNER JOIN tipdatabase!current  ;
ON t.tip_id = current.tip_id ;
WHERE ALLTRIM(current.sc1_2000) == "STP"

But this

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"

Produces no records. Same result with ANSI on.




>Change to
>

>WHERE ALLTRIM(eval(thisfield)) == "STP"
>

>
>See http://www.berezniker.com/content/pages/visual-foxpro/string-comparison-vfp for explanation
>
>
>>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