ISDleftovers
Technical User
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.
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.