I use VB6 with Oracle database. I also use Adodc and datagrid for retrieving data from database. If i do search with Select.....Where name IN(LIKE) '" & Text1.text & "' does return nothing. I have to type exact value be searched.
Why do you think that IN or LIKE doesn't return any data?