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 enter the partial sale order number and Inquiry provides the result.
Microsoft provide Like operator , I used it with text box in below code snippet. Suppose strProcumentValue is string edit control with auto declaration as true.
select * from _Table where _Table.PurchId like “*” + strProcumentValue.text() +”*”;
if (_Table !=null)
Its works for me,