Weller0123
asked on
VB.NET sql connection statement syntax question...
I need to query a DB using a variable from a textbox. The strSearch will hold the string to search for using the LIKE option.
How do I use a variable (strSearch) in the SQL statement with the % wildcard?
Where (T4.PROJ_ID LIKE %'strSearch'%) ??? That isn't right...
Is this SQL syntax or VB?
Thanks in advance...
How do I use a variable (strSearch) in the SQL statement with the % wildcard?
Where (T4.PROJ_ID LIKE %'strSearch'%) ??? That isn't right...
Is this SQL syntax or VB?
Thanks in advance...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.