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 |
|
jstratham84
Starting Member
2 Posts |
 Posted - 2006-04-02 : 15:50:49
|
| Hello, I have the following table:name idalex 111-23bertha 231-04bill NULLchris NULLlauren 634-82I am trying to write a query that will find all the records where the id column is NULL. What would the output be? Can you help me? Thanks. |
|
|
jstratham84
Starting Member
2 Posts |
Posted - 2006-04-02 : 15:51:40
|
| name and id are seperate columns... the post didnt look good |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-04-02 : 16:55:33
|
| have a look at the IS NULL clause.rockmoose |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-02 : 22:37:53
|
| R u looking for something like:Select ..... from ..... Where ID is NullSrinika |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-04-03 : 01:47:52
|
quote:
Originally posted by jstratham84
name and id are seperate columns... the post didnt look good
You should use code tag to make it clearer  name idalex 111-23bertha 231-04bill NULLchris NULLauren 634-82 MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
How to find all records with a column id of NULL?