asked on
I need help with this SQl Statement
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 & %'"
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 & %'"
Microsoft SQL Server
Last Comment
Habib Pourfard
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
if strLicense is the name of a TextBox then replace it with: strLicense.Text
Dim strQuery As String = "Select * FROM PersonOfInterest WHERE PK_DriverLicenseID_vch Like '" & strLicense.Text & "%'"
Error.jpg