Partial Search of Access Db from VB

[ISDleftovers]

I have a small application which needs to search through five fields and display the matching records to the user, at the moment the search works, but the user needs to enter the full name of a company to get any details at all.

I do not have the MSDN library and at the moment I am using the "Like" keyword, but this does not do partial matching (eg: to find ISD Consulting the user must enter "ISD Consulting" [case sensitive], I would like it to find ISD Consulting and other matches if "is" is entered)as I had hoped it would.

What keyword or function do I need to use instead of or with the "Like " keyword to make a partial search work.

 

[MatsHulten]

This query works fine for me in access 2K:
SELECT user_.*
FROM user_
WHERE (((user_.Fnamn) Like "m*&quot);

The query is case insensitive.

Suggest that you try out how the qury should look in Access and then export it to the VB code.

I have never heard of a MS product that is case-sensitive, but that may well be something in the settings of youre DB, most likely nothing in youre VB code.

Good Luck
-Mats

 

[hellovb]

You could try using the LIKE operator combined with the following pattern matching character; %

 

[ISDleftovers]

cool, thanks guys, I got it working,
my only problem is that it is still case sensitive and I can't find any reason for it to be
but at the moment just having it work as well as it does is fine, case insensitive would just be a bonus (really nice but not neccessary)

Thanks again
BJK