Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bwaard
Starting Member
1 Post |
 Posted - 2004-05-11 : 14:04:58
|
| hey all, I'm grabbing info from an access database, and using it to create drop-down boxes. Do yo know how I can ignore the blank rows from the database?thanks!!Brandon |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-11 : 15:01:00
|
| Why are there blank rows?Which columns are blank? Do you mean NULL values?Just add a WHERE clause to ignore certain rows.SELECT...FROM...WHERE Column1 IS NOT NULLTara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-11 : 15:01:47
|
| I believe Access has a function called ISEMPTY. You can use this. It's been awhile though, so I might not be right about this.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Database Blank Rows