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

A horrible waste of space :) I also see that ISBLANK was specifically designed to handle "blank" values in logicals, so I guess I stand corrected....

Tom