Passing Parameters to Stored Procedures

[harrysdad]

Hi there. I am attempting to use asp to run a query as a stored procedure in access. It works ok, as long as I use an = operator and match a string exactly. The problem is I want to use the LIKE operator in the query, and I can't work out how to do this via the asp page. Can anyone help?

regards

Tony

 

[SnaveBelac]

It would useful if you could post your existing code here along with the error you are recieving.

Also, check your datatypes. if you are using string values then you must put the WHERE condition in single quotes.

The LIKE operator uses *'s as wildcard characters.

----------------------------
SnaveBelac - Adventurer
----------------------------