>>>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.
Or just put not (my query) :P
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges