>>>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
In some cases people will consider a NULL value as empty too (even though it's really not). That is the ISNULL() function...
ICQ 10556 (ya), 254117