Currently I am writing an Inquiry for Client. For this inquiry I have to use Like operator functionality. For example end user wants to search Sale Orders. For this he/she enters the partial sale order number and Inquiry provides the result.
Microsoft provides “Like operator” functionality , I used it with text box in below code snippet. Suppose strProcumentValue is string edit control with auto declaration true.
void clicked()
{
PurchTable _Table;
super();
select * from _Table where _Table.PurchId like “*” + strProcumentValue.text() +”*”;
if (_Table !=null)
{
info(“found”);
}
}
Its works for me,
reference: http://daxdude.blogspot.com/2011/02/use-x-wildcard-like-and-not-like-in-x.html