Wildcards Searches using Query Builder in VB.NET

What do I use to complete Wildcards searches connected to Access database via VB.Net frontend in the Query Builder in VB.NET.
I have tried = ? in the FILTER column in the Query Builder, this make you type in the full string in the search field. My SQL looks like this:
SELECT     CARRIERID, ACCOUNTID, MEMBERID, MBRLSTNME, MBRFSTNME, RXNUMBER, DTEFILLED, RBLDUEAMT, CHECK_NUMBER, CHECK_DATE,
                      CHECK_BALANCING
FROM         RXCLAIM
WHERE     (CHECK_NUMBER = ?)
GeneBatAsked:
Who is Participating?
 
surajgupthaConnect With a Mentor Commented:
try **** where name LIKE '112%'  ****
try **** where name LIKE '112*'  ****

Dont forget the quotes and try it along with * and %
0
 
surajgupthaCommented:
Do you mean to search all check numbers beginning with a specific number?
Have you tried the LIKE clause?
0
 
GeneBatAuthor Commented:
I'm trying to use the Query Builder in VB.NET under data binding I tried LIKE ? and you have to type out the entire string: example 11223344. I would like the user to just type 112 and it brings back all record that start with that string.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
surajgupthaCommented:
try LIKE and append your 112 with a * so its 112*
0
 
GeneBatAuthor Commented:
That doesn't work coming from VB.Net's Query Builder tool connecting to a Access Database backend... It works in Access but not in the Visual Studio VB.NET Query Builder which looks like Access Query Builder.
0
 
surajgupthaCommented:
Let the query builder tool use some query and then after it generates the code, modify it to have the like clause
0
 
GeneBatAuthor Commented:
I tried that and it doesn't work?  I used a WHERE Clause with  LIKE 112* and it does nothing.
0
 
GeneBatAuthor Commented:
Thanks for your answer it worked perfectly in the Query Builder inside VB.NET 2005. I can now use that very slick Query Builder to make all kinds of Parameter Queries, Lookups and the like in the VB.NET Designer.
Again Thanks,
GB
0
 
surajgupthaCommented:
You are welcome :)
Best of Luck
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.