ACCESS 2003 SQL LIKE Operator not working in VB6 runtime
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 & "*'"
Have a good day.