The IS NOT NULL clause is used to check whether or not a column in a table contains NULL values. The IS NOT NULL clause returns all the rows of a column that does not have NULL values.
The following example will demonstrate the use of the IS NOT NULL clause:
This statement will retrieve the CustID of all customers whose Fname does not contain any empty string.
- Click here to get free mcad MCAD exam practice questions.
- Download free practice test for mcitp MCITP exam.
- Become Microsoft MCITP Database Developer certified.
- Pass Microsoft mcitp-database-developer-2005 - MCITP Database Developer-2005
- Best exam simulation Microsoft mcitp-sql-server download free trial.
- Download free practice test for Microsoft MCP exam.
- Click here to get free mcsa-2000-to-2003 MCSA 2000 to 2003 exam practice questions.
- Click here to download mcsa-to-mcse-2003 test study guide and practice question.
- Get certified in first attempt download mcse-2003 - MCSE simulation.
- Become Microsoft MCTS SQL Server 2005 certified.
- Download free practice test for 70-431 SQL Server 2005 Implementation exam.
- Pass Microsoft 70-441 - PRO: SQL Server 2005 Designing Solutions
Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
