[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1143
  • Last Modified:

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 = ?)
0
GeneBat
Asked:
GeneBat
  • 5
  • 4
1 Solution
 
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
 
surajgupthaCommented:
try LIKE and append your 112 with a * so its 112*
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
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
 
surajgupthaCommented:
try **** where name LIKE '112%'  ****
try **** where name LIKE '112*'  ****

Dont forget the quotes and try it along with * and %
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now