Thanks Phil!  Great idea.  I've incorporated it into my code and it works beautifully!  Thanks again.  Saved me alot of time writing a cursor to loop through and remove the...

Hi All....  I spent the day looking through SQL Books online and can't find the proper construct for this....  The frustrating thing is that I saw it yesterday 

Thanks Journey Man.  Still pulling my hair out though!!!!  I get this as a result when I try the Bitwise operator.   I can't believe such a relatively easy concept is...

Jim - Thanks for your reply!  I tried that recommendation but didn't have any success.  Maybe I oversimplified the statement of the problem.

THe original query was this:

SELECT     distinct ti.tactical_issue_id as...