Thanks chris, this works!

Thanks guys for your quick response. I tried Noeld's solution and it worked, I liked the simplicity of the select statement. But I am not sure about chris's solution, where...

I am sorry, I should have provided that info. The field type is tinyint so the values are 0 & 1. Thanks.