Jeff,

>> myMask = 2^1 + 2 ^8
>> SELECT  mycolumns
>> FROM  mytable
>> WHERE  BigIntColumn & #myMask# = #myMask#


This was exactly what I was doing - irrespective of the CAST to change data
types - but it will only select records that have bit 1 AND Bit 8. What I
need to do is to select records that contain Bit 1 OR Bit 8. (example values
only)

Example:  Given these values

BigIntColumn
==================
1
2
4
8
128
129
256
257

Select 
==============
1 = (bit 1)
5 = (bit 1 + bit 3)
128 = (bit 8)
129 = (bit 1 + bit 8
257 = (bit 1 + bit 9)



I am so confused :(


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:298255
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to