Retrieve row based column having null value in sql2000

Expand Post »

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; Nov 7th, 2009 at 8:01 am.

Similar Threads

Pointers in C++
Repair Access database in VB.NET
public Component getTableCellRendererComponent() method problem in Java
Cannot retrieve data with function in PHP
memory management in wndows 2000 in Windows NT / 2000 / XP

shine_jose

Reputation Points: 4

Solved Threads: 2

Light Poster

Offline

48 posts
since Jul 2009

Permalink

Nov 7th, 2009

Re: Retrieve row based column having null value in sql2000

MS SQL Syntax (Toggle Plain Text)
SELECT * FROM TABLE WHERE col1 IS NULL
Select * From Table Where col1 Is Null

Replace "Table" with your table name
Replace "col1" with your column name

Last edited by sknake; Nov 7th, 2009 at 9:06 am.

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: 'UPDATE'ing table with same value over and over again!

Next Thread in MS SQL Forum Timeline: Tables appear under wrong database in SQL Server Mgmt. Studio Express

DaniWeb Message

Cancel Changes

User Name
Password