Pass wildcard character (%) as parameter to stored procedures

S

Siddharth Parekh

Hey,

Can anyone tell me how to pass a wildcard character based on user input to a stored procedure?

I can make it work by adding it to the parameter in the stored procedure itself. For example Description LIKE @desc + '%'.
But i want it to leave it to the user to enter the wildcard if he wants to. Is it possible to do so? Am using ADP's.

Thanks in advance,
Siddharth.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

issue with Form parameters 1
Accessing Stored Procedure via VBA 4
Access ADP Form and Stored Procedure as RecordSource Options 2
Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
How to open stored procedure w/param from control 6
Compatibility (2002->2003) 8
Running a Stored Procedure Using a Form Event 5
Repeated Parameter Passing - ADP to SQL 2000 2

Top