I
Ivar
Hi All
I have a Table, In the table I have a field DataType Long Integer.
I want to determine if a value in this field is true or false using the AND
bitwise operator using SQL Query
Something Like:
SELECT TblName.Reference, TblName.BitFlags, (TblName.BitFlags And 512) AS
Expr1
FROM TblName;
The query runs but Expr1 is always true except when TblName.BitFlags is 0.
I'm assuming that if TblName.BitFlags <> 0 then that's true, if the number
<> 0 then that's true so Expr1 is also true
Can SQL handle what I'm asking it to do? If so then How Please
Thanks
Ivar
I have a Table, In the table I have a field DataType Long Integer.
I want to determine if a value in this field is true or false using the AND
bitwise operator using SQL Query
Something Like:
SELECT TblName.Reference, TblName.BitFlags, (TblName.BitFlags And 512) AS
Expr1
FROM TblName;
The query runs but Expr1 is always true except when TblName.BitFlags is 0.
I'm assuming that if TblName.BitFlags <> 0 then that's true, if the number
<> 0 then that's true so Expr1 is also true
Can SQL handle what I'm asking it to do? If so then How Please
Thanks
Ivar