>>I have table merit.dbf having fields Regno, applno, Mathsec, Physec, Chemsec. In my table some records fields value are empty, so I want to extract those records in my table. How to write sql query for the same?
>
>
Select * from merit where empty(regno) or empty(applno) or ....
>If the fields are really blank, you can use isblank() instead of empty()
If you want a truly empty record, you should use AND instead of OR...
Menachem