Need help developing a "Search" application

[ignatiusw]

Hi, I've been asked to develop my company's library catalogue, which includes search function. The search is not a simple one, but it has to be able to take keywords like AND, NOT, OR, and also search whole words or any of each words (e.g., "My Book Title" vs My Book Title).
I've tried to look on the net but failed (most likely I don't use the right search words). I haven't developed applications to do advance "search" like this before, so any help or info or guidance is most appreciated.
Is there any codes already published for what I need? The company don't want to pay anything (other than my time) since this is for internal application. And no, my company is not a software development company. I happen to be the only database administrator & programmer in the company

Thanks!

 

[Phill64]

hehe, same thread as other forum

 

[ignatiusw]

Yes indeed
I just thought in case I didn't get any response in one of the forum, I would get one from the other forum. I've guessed that some members (if not all!) would be in both forum. These 2 are different forums, correct?

Mod can close this thread if wanted as it's been answered in vbforum. Thanks!