I suspect that my question will have an easy answer, but I can't find any mention of it in my ASP.NET books:

I have a table of items where one column is a boolean checkbox field called "Approved". I want to display records from this field in my gridview control only where "Approved" = TRUE.

In order to filter data by this boolean field, should I use a WHERE statement such as "WHERE Approved = 1 ", or an IN operator statement such as "WHERE Approved IN ("TRUE"), or some other construction?

Thank you very much for your help.

Hi there.. the first one you posted will just work fine. Not need to use a IN clause in this case.

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Thank you, I will use this!