>>I have student.dbf with fileds 1.regno(C), 2.name(C), 3.dob(D), 4.Course(C), 5.category(C)
>>
>>How to write SQL Query for find empty value of all field of my "student.dbf" table?
>
>I am not sure if I am reading well your request, for the answers you've got are not as I understood the question, this is what I thought you wanted:
>
>
>SELECT * FROM Student WHERE EMPTY(RegNo + Name + Course + Category) and EMPTY(DOB)
>
>
>That will give you the records that have all the fields empty (empty value of all field)?
If we want to find an empty record (all fields to be empty), then just change OR to AND in my query.
If it's not broken, fix it until it is.
My Blog