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 |
|
Sim
Starting Member
12 Posts |
 Posted - 2006-03-28 : 15:26:03
|
| Is this an incorrect way to query for rows with NULLSelect * from Table1where date = NULL |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-28 : 15:36:08
|
| WHERE [date] IS NULLTara Kizeraka tduggan |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-28 : 16:14:44
|
| Null doesn't technically represent missing data. It represents indeterminate data. And since it is indeterminate, Null never "equals" anything. Not even other nulls. |
|
|
|
Sim
Starting Member
12 Posts |
Posted - 2006-03-28 : 16:21:40
|
| thanks |
|
|
|
|
|
|
Selecting for Null