asked
How do I sort out empty data cells in a table?
In a query, how do I sort out the cells which are entered just by using spaces instead of any text?
If someone enters a space, you can search for it in a WHERE clause using ' ' like this: ...WHERE a.ColX = ' '; But if someone enters more than one space, this won't return. Unfortunately, then, you're going to have to use some type of function on the column that's likely to result in a scan. Or, by empty are you referring to the columns that are NULL? Then you can use IS NULL or IS NOT NULL in the WHERE clause: ...WHERE a.ColX IS NOT NULL; That would return all the places where there were values in the column.
16 People are following this question.
