SQL In Operator in D365FO
Microsoft Introduce In Operator in X++ Syntax, but it will work with Enums only.
Following are the example how you can use this
SalesTable salesTable;container con = [SalesType::Sales, SalesType::ReturnItem, SalesType::Subscription];while select SalesId from salesTablewhere salesTable.SalesType in con{Info(salesTable.SalesId);}