Hi,
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?
Thanks

Hi,
You can use * in like operator. * represents multiple character match of MS Access Databases.
Example SELECT * FROM Table WHERE Name LIKE *a* For single character use ?

Sorted.

...LIKE '%" + Text1.Text + "%'

Thanks