Compare texts string in VB .NET

[Chong]

I need help on comparing a word or phrase enter by a user at run time to a MS Access database field format as memo. The Access field contains around a thousand characters of words and/or phrases and I need to compare if there is any match with any of the phrases or words in the memo field of the mdb database. The comparison doesn't have to be exactly match the case, space, order, or the full word or phrase. A great example of what I want to do is the search tool in Windows 2000 when you click Start/Search/For Files or Folders... But in this case I want to compare to a string variable that store the contents of the memo field from my MS Access mdb file.

If anyone has any idea, please give me a helping hand on this issue.

Many thanks in advance!

Chong

[MrGTI]

What's the question?

All you want to do is compare an inputed value with text already in a database. It's just a SQL statement.

[Chong]

I want to compare a text entered by a user at run time and compare if what the user typed match any of the words or phrases in the database field that is formated as memo. I could compare during the SQL query or after the contents brought into a string variable, but the problem is I don't know what is the best way and how to do it.

Chong

[MrGTI]

It's better to do the comparison at the database level. The SQL will return a DataSet of all entries that match.

[Chong]

Thanks! I'll give that a try first. If I have any problem, I'll sure let you know.

Chong