Hi All,

I am using VB6 script via ADO objects to read ACCESS 2003 backend database using SQL String LIKE Operator. It doesn't seem to be working. I tested the SQL string under ACCESS 2003 Query mode and it's OK but not in VB6 runtime. What the Sales Manager wanted is instead of keying in the complete 8 digits SalesOrder number he wants to key in only the first 3 digits and the SQL string will extract all transactions that matches the first 3 digits and display it in LISTVIEW CONTROL where he can select the specific line item. Please help me.

Here is the SQL string :
SalesOrder datatype is numeric

"Select SalesOrder from TblSalesTrans where (SalesOrder) like '" & txtSalesOrder & "*'"

Thank you,
Have a good day.