>>>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 .... && list the rest of the fields in question

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

In some cases people will consider a NULL value as empty too (even though it's really not). That is the ISNULL() function...