>I have a table namely "student.dbf" havind the fields 1. Regno (I), 2. Name (C), 3. Caste (C), 4. Maths (I), 5. Physics (I), 6. Biology (I).
>
>
>I want to select the empty field value record for all the field.
>
>How to do this?

Note that it is not wise to name fields like VFP keywords like name

What means select the? empty field value record?

SQL SELECT?

SELECT:
 Cur1.*;
 FROM Student AS Cur1;
 WHERE EMPTY(RegnoI);
  AND EMPTY(Cur1.Name);
  AND EMPTY(Cur1.Caste);
  AND EMPTY(Cur1.Maths);
  AND EMPTY(Cur1.Physics);
  AND EMPTY(Cur1.Biology)

locate?

SELECT Student
LOCATE FOR EMPTY(RegnoI);
  AND EMPTY(Name);
  AND EMPTY(Caste);
  AND EMPTY(Maths);
  AND EMPTY(Physics);
  AND EMPTY(Biology)

browse?

SELECT Student
BROWSE FOR EMPTY(RegnoI);
  AND EMPTY(Name);
  AND EMPTY(Caste);
  AND EMPTY(Maths);
  AND EMPTY(Physics);
  AND EMPTY(Biology)