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.

Select * From Table Where col1 Is Null

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.