Member Avatar for iefilec

hi. i'm doing a search option in my system where if your searching for a entry even if you didnt typed the whole word, all of the entry that contains the letters that you have typed will appear, well i really cant explain it but it goes like this if i have entries: reserve,reservoir,restaurant,jaded,mend,feed in my database and the searcher typed "res" all the word containing res will appear. i know it has something to do with the like parameter but i just cant do the code right. please help me..

  • 2 Contributors
  • 4 Replies
  • 253 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Mitja Bonca
Member Avatar for Mitja Bonca

Hi, please check here how to use Like condition. Its all well explained.
bye

Member Avatar for iefilec

hi. thanks for the link. i have read the explanation but my code still wont work. i have a access database connected to vb.net.i have this:

dim str as string = "boo"

SELECT * FROM table WHERE title LIKE '%" & str & "%'

but still, it wont list all the entries having "boo"

i hope you could help me. thanks

Member Avatar for iefilec

hi.thank God i have figured out why it isn't working. HAHA! thanks Mitja Bonca that link was useful :)

Member Avatar for Mitja Bonca

You are welcome.
Iam glad you worked it out.

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.