>How can I create an SQL statement that gets all records of one field value and the true condition of a second field or a not empty of a third field?

Steven

SELECT SomeTbl.* FROM SomeTbl WHERE SomeTbl.field1 = xyz AND ( SomeTbl.field2 = .T. OR !EMPTY(SomeTbl.field3) )

HTH
Mike