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


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