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

Actualy a logical can store True and False wich internaly could be represented in different way depending on the language.

Having a "blank" value doesn't make sense.

You're right but that's the only way foxpro represented "null" values in the version 2.6

The ISBLANK() function IMO is the one that's not working properly.

It works properly on the record by record basis but not in Sql Select.

I agree with Craig that the only way to get another value is to have the field be NULL.

Where in my message did I disagree with Craig on this one?

Again, IMO.....

The same here :)