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.
- Download practice question and study guide for mcad for exam.
- Best exam simulation Microsoft mcitp download free trial.
- Download free practice test for Microsoft MCITP Database Developer exam.
- Pass MCITP Database Developer-2005 in first attampt.
- Become Microsoft MCITP Microsoft SQL Server certified.
- Best exam simulation Microsoft mcp download free trial.
- Download free practice test for Microsoft MCSA 2000 to 2003 exam.
- Get certified in first attempt download mcsa-to-mcse-2003 - MCSA to MCSE-2003 simulation.
- Become Microsoft MCSE certified.
- Get certified in first attempt download mcts-sql-server-2005 - MCTS SQL Server 2005 simulation.
- Download free practice test for Microsoft SQL Server 2005 Implementation exam.
- Click here to get free 70-441 PRO: SQL Server 2005 Designing Solutions exam practice questions.
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.
