This is how SQL works. One NULL value never equals another NULL value. If you want to search for NULL values, use the "is null" idiom as you've done.
posted 15 years ago
Thanks for your immediate reply..
Actually, the input parameter is variable one..It can have some value or can be null. How can i change the query in prepared statement, based on the input param value ? can you please advise me. thanks.