Re: Help With Field Searching Using Wildcards
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 27 Mar 2007 14:39:03 -0400
Andy wrote:
Hi GangThe same way. Only have your users use the ODBC wildcards (% and _) not
I have a small database application where the user can search
different fields. They select what they want to search on and enter a
value to search on. For example
They select part number and enter "123" into the search field.
This searches the database for that field with LIKE '%123%'.
What I want the user to be able to do is add wildcards to the search.
For example
They select the part description field and enter "Dohicky*123" or
"Dohicky?123"
I want the search to process the wildcards as you would expect. What
is the easiest way to do this?
the Jet wildcards
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- Follow-Ups:
- References:
- Help With Field Searching Using Wildcards
- From: Andy
- Help With Field Searching Using Wildcards
- Prev by Date: Help With Field Searching Using Wildcards
- Next by Date: Re: Help With Field Searching Using Wildcards
- Previous by thread: Help With Field Searching Using Wildcards
- Next by thread: Re: Help With Field Searching Using Wildcards
- Index(es):
Relevant Pages
|
