Member Avatar for shine_jose

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.

Edited by shine_jose because: n/a
  • 2 Contributors
  • 1 Reply
  • 136 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by sknake
Member Avatar for sknake 
Select * From Table Where col1 Is Null

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

Edited by sknake because: n/a
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.