var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: query using binary style in the WHERE side?
I'm trying to filter my results using the following "binary style" query:
SELECT * FROM table_1 WHERE ((field_1 AND 7) = field_1)
SELECT * FROM table_1 WHERE ((field_1 = 1) or (field_1 = 2) or (field_1 = 4))
The Jet Engine will always interpret AND and OR as logical operators. You can create a public function (in an independent module):
Public Function BitAnd(ByVal Value1 As Variant, ByVal Value2 As Variant) As Variant
BitAnd = Value1 And Value2
Notice that the need for this kind of criteria is a sign that your database probably violates the first normal form.
Have a nice day!
Thanks for the idea, I will try this.
Tags for this Thread