troubleshooting Question

I need help with this SQl Statement

Avatar of jjc9809
jjc9809 asked on
Microsoft SQL Server
4 Comments2 Solutions343 ViewsLast Modified:
Hi Everyone,

I have this SQL Statement that isgiving me a ssyntax error.  What is wrong with the coding?
I have quotes wroing somehow.

This statement should pull a record by a Driver License Number entered in the textbox called strlicense when an event button is selected.

The statement:

Dim strQuery As String = "Select * FROM PersonOfInterest WHERE PK_DriverLicenseID_vch Like '"& strLicense & %'"
ASKER CERTIFIED SOLUTION
Habib Pourfard
Senior Software Engineer
Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros