X++:
static void Job46(Args _args)
{
Query q=new Query();
QueryBuildDataSource qbds;
QueryRun qr;
VendTable vendTable;
;
q.addDataSource(tableNum(VendTable)).addRange(fieldNum(Vendtable, accountNum)).value('!*\\*');
qr = new QueryRun(q);
while (qr.next())
{
vendTable = qr.get(tableNum(VendTable));
info (vendTable.AccountNum);
}
}