Skip to main content
Axiom Docs home page
Search...
⌘K
Ask AI
Blog
Support
Launch Axiom
Launch Axiom
Search...
Navigation
Set membership operators
Set membership operators
Documentation
Query reference
API reference
Get started
Introduction
Example queries
All features
Functions
Scalar functions
Aggregation functions
Operators
Tabular operators
Scalar operators
Set membership operators
Overview
in
!in
in~
!in~
Logical
Numerical
String
Reference
Reference
Migration
Migration
Operators
Scalar operators
Set membership operators
Set membership operators
Copy page
Learn how to use and combine different set membership operators in APL
Copy page
The table summarizes the set membership operators available in APL. These operators filter records based on whether a value matches any element in a specified set.
Name
Description
Case-sensitive
in
Returns
true
if the value equals any of the elements.
Yes
!in
Returns
true
if the value doesn’t equal any of the elements.
Yes
in~
Returns
true
if the value equals any of the elements.
No
!in~
Returns
true
if the value doesn’t equal any of the elements.
No
Was this page helpful?
Yes
No
Suggest edits
Raise issue
where
Previous
in
Next
⌘I