Member Avatar for veledrom

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
  • 87 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by veledrom
Member Avatar for selvaganapathy

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 ?

Member Avatar for veledrom

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.