Code: Select all
...
from item in items
where
item.Status.HasFlag(MyStatusEnum.Value1)
Code: Select all
...
WHERE TO_NUMBER(BITAND("d".Status, Value1)) = 2
If you use the bit-operator "&" the sql works correctly.
Code: Select all
...
from item in items
where
item.Status.HasFlag(MyStatusEnum.Value1)
Code: Select all
...
WHERE TO_NUMBER(BITAND("d".Status, Value1)) = 2