Mine did too, but you guys didn't read the question properly. It says select all that apply! And a little check in BOL would have revealed that IS_MEMBER can return 0, 1 or NULL, so no points back 😉
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]