Hi Pauline,

As you said the field is logical, then I think you have to use the query as follows:

SELECT
property.`property`,
property.`known_as`,
property.`current`
FROM
`property` property
WHERE
property.`current` = .T.

cheers,

PK