SQL "IN" Operator

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 salesTable

where salesTable.SalesType in con

{

Info(salesTable.SalesId);

}