Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

VB & LIKE clause!

Hello!

I developped a VB program that use Access as its DB backend. All my query are successful but one which is:

SELECT * FROM tblClients WHERE (tblClients.Nom) Like 'camio*' ORDER BY Nom

the above is generated from my VB program (I pasted it from the VB Espions. It returns 0 rows but when I paste this query directly into Access, it returns 50 rows which are what I would like to happen in my VB program :)

If anyone has a tips or a pointer to the right direction to use.. I'd appreciate it.

Mart
0
nfuids
Asked:
nfuids
1 Solution
 
BWarmuskerkenCommented:
replace the * with a %
0
 
nfuidsAuthor Commented:
Thanks a lot, it worked :)

I thought I had tried it.. but I guess not :P
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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