IsSet
Returns True if an integer value matches a specified mask.
Syntax
IsSet(<value>, <mask>)
Parameters
<value>
Type: Long
Data value to test.
<mask>
Type: Long
Pattern of bits to check.
(return)
Type: Boolean
Whether all the bits set in Mask are set in <value>.
Notes
If Mask is zero (no bits set), the return value is True. If the current data value is NULL, <value> is 0 and the return value is False.
This function is equivalent to the expression:
BitAnd(Val, Mask) = Mask
Example
The following example selects only records where Respondent.Serial is an odd number.
SELECT * FROM vdata
WHERE Respondent.Serial.IsSet(1)
See also