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

>If you convert this to a VFP table you can add NULL to the field. This way, going forward, if the field was never populated, it will be NULL. However, there is no way you can go back to existing records and determine which ones were populated and which were not.

Yes, you can determine if a field was populated or not using ISBLANK() function. After converting you can run following REPLACE command

REPLACE FOR ISBLANK(eclrhse) eclrhse WITH Null

It would work for any type of field but character.


>>Hello UT,
>>
>>select * from ster where SubStr(sunum,1,1) = "E" .AND. eclrhse == .F.
>>
>>returns cursor containing "unknown" or "unmarked" records as well.
>>(logical not known yet)
>>How may I return only records containing marked-logical-False?