>>>It's interesting to see all the different solutions that people are recommending. However, NOTHING will work. Since you say this is a legacy table, you can only get two values. .T. and .F.
>>
>>It's not totaly true. In the browse you can see T, F and empty values in the logical field. ISBLANK() function would return .T. for the empty values on record per record processing. Unfortunatelly, it doesn't work properly in SQL Select.
>
>A logical can only store 0 or 1. Having a "blank" value doesn't make sense. The ISBLANK() function IMO is the one that's not working properly. I agree with Craig that the only way to get another value is to have the field be NULL. Again, IMO.....
>
>Tom

Ah, but what about the other 7 bits in that byte that VFP uses to store a logical?

Jay