CanMan2004 Posted February 12, 2007 Share Posted February 12, 2007 Hi all Im trying to do a simple query to pick up all rows which have no value in one of there fields. The problem is that all rows which have NULL as a defult value, are not treated as empty. How can I make the query read NULL as an empty field? Thanks Ed Quote Link to comment Share on other sites More sharing options...
paul2463 Posted February 12, 2007 Share Posted February 12, 2007 can you not make the query pick up both cases anyway $query = "SELECT idrow FROM table WHERE column = '' OR column IS NULL" Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.