I am hoping an SQL guru can assist me with what I am sure is a stupid little oversight or misunderstanding on my part.
I hope I can explain this. I need to do a bit evaluation against data in the database where the data is stored in a BigInit column. Within my code I construct a bit filter and need to select all records where the logical AND of that value against the BigInt field is "true". For example If my bit filter = 129 (1*2) + (8*2) What I need to do is select all records Where the BigInt Column has bit 1 AND bit 8. I am not sure how to evaluate this function in a where clause. SELECT mycolumns FROM mytable WHERE BigIntColumn & CAST(#filter# as BigInt)) = {and this is where I fall down} Any help is appreciated. 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:298232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4