Wildcard search in Dynamics AX

If you have to add functionality similar to wildcard like operator.

Select * from VendTable where VendTable.Name is like ‘%Vendor XYZ%’

You can use static functions SysQuery::valueLike and SysQuery::ValueLikeAfter.I used these functions in datasource ExecuteQuery() method

QueryBuildRange vendorFilter = SysQuery::findOrCreateRange(PGDFileline_q.dataSourceTable(tablenum(vendTable)),fieldNum(VendTable,AccountNum));

if (vendTxt.text()!="")
{
vendorFilter.value(SysQuery::valueLikeAfter(vendTxt.text()));
}
else
{
vendorFilter.value(SysQuery::valueUnlimited());
}

super();