Retrieve row based column having null value in sql2000

Please support our MS SQL advertiser: Intel Parallel Studio Home
Thread Solved

Join Date: Jul 2009
Posts: 17
Reputation: shine_jose has a little shameless behaviour in the past 
Solved Threads: 0
shine_jose shine_jose is offline Offline
Newbie Poster

Retrieve row based column having null value in sql2000

 
0
  #1
16 Days Ago
Hello
i wish to retrieve rows from a table based on a particular column which contains null values in sql2000 server I try ed a lot but its not working please help me.
Last edited by shine_jose; 16 Days Ago at 8:01 am.
Reply With Quote Quick reply to this message  
Join Date: Feb 2009
Posts: 3,187
Reputation: sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of 
Solved Threads: 571
Sponsor
sknake's Avatar
sknake sknake is offline Offline
.NET Enthusiast
 
0
  #2
16 Days Ago
  1. SELECT * FROM TABLE WHERE col1 IS NULL

Replace "Table" with your table name
Replace "col1" with your column name
Last edited by sknake; 16 Days Ago at 9:06 am.
Scott Knake
Custom Software Development
Apex Software, Inc.
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC