Skip to main content

How to use "LIKE" operator in QueryBuildRange

To make something as the LIKE operator in a query, just assign a value to the QueryRange including a wildcard.

static void QueryBuildRange_Sample(Args _args)
{
Query query = new Query();
QueryRun queryRun;
QueryBuildDataSource qbds;
QueryBuildRange queryRange;
CustTable custTable;

qbds.addDataSource(tableNum(CustTable));

queryRange = qbds.addRange(fieldNum(CustTable, AccountNum));

queryRange.value("axd*");

queryRun = new QueryRun(query);

while(queryRun.next())
{
custTable = queryRun.get(tableNum(CustTable));
print custTable.AccountNum;
}
pause;
}