>> You need a bitwise operator.  Bit and is & in MS SQL
>> SELECT  mycolumns
>> FROM  mytable
>> WHERE  bit_column & 128 = 128

This was essentially what I was doing but it does not work properly for
matching multiple bits in the "bit_column",  Example: matching a row that
has Bit 1 and Bit 8 (129) or matching a row that has Bit 1 and Bit 4 (9).

Is my only choice looping over the filter and dynamically constructing the
Where clause from the binary value of the "filter"? 



Best Regards,

Dennis Powers
UXB Internet - A website design and Hosting Company
690 Wolcott Road
P.O. Box 6029
Wolcott, CT  06716
Tel: (203)879-2844
http://www.uxbinternet.com/
http://www.uxb.net/



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298245
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to