Q
Problem solve Get help with specific problems with your technologies, process and projects.

Checking for NULL records in all columns in Access

I have an Access database with multiple tables. Is there a way to check for all the NULL records in all the columns without doing a 'WHERE IS NULL' on each column individually like:
 WHERE Test1.col1 IS NULL, Test1.col2 IS NULL;
I am looking for a wild card approach.

Well, sorry but the answer is no. The WHERE clause in Access does not have that kind of approach, and it can only contain up to 40 expressions linked by logical operators. There are some options in SQL Server like CONTAINSTABLE, but it's used to locate strings in all the records from a previous Full Text Indexed Table.

 

For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close