Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select blank record
Message
From
29/06/2012 05:58:46
 
 
To
29/06/2012 05:54:43
Muthu Vel
Sty Company
India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01547193
Message ID:
01547194
Views:
49
>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()
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform