0

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

2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by veledrom
0

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 ?

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.