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
veledrom
32
Master Poster
Recommended Answers
Jump to PostHi,
You can use * in like operator. * represents multiple character match of MS Access Databases.
ExampleSELECT * FROM Table WHERE Name LIKE *a*For single character use ?
All 2 Replies
selvaganapathy
31
Posting Pro
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 ?
veledrom
32
Master Poster
Sorted.
...LIKE '%" + Text1.Text + "%'Thanks
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.