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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2003-04-29 : 17:45:48
|
I have a table look like: A B---------------- Null 1 Null Null 2 Null and am trying to get rid of the row that has two null columns.So, the output look like: A B------------ Null 1 2 Null How do i compare the null value in different columns at the same time? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-29 : 18:12:25
|
| This should work:SELECT A, B FROM Table1WHERE A IS NOT NULL OR B IS NOT NULL TaraEdited by - tduggan on 04/29/2003 18:17:20 |
 |
|
|
|
|
|
Null compar