prompting for user input

[deekatz]

I am very new to SQL. Been using MSAccess all these time. I have a question about user input. In Access if I want the user to supply a criteria for a query I can do something like this:
SELECT * FROM tblRides WHERE RideDate BETWEEN [StartDate] and [EndDate]
My user will enter the start date and end date in the Access generated user input form depending on what dates they want to work with.
I tried to do the same thing in SQL, it doesn't seem to work. How can I accomplish this task in SQL? What do I need to do to allow user to input whatever date they want. All the examples that I've seen so far have the dates hardcoded in the Select statement. Thank you in advance for your help.

[MAK]

When you say SQL I believe you are talking about SQL Server.

Access has frontend and backend. But sql server is a database engine. you cannot prompt the user to input values with GUI

But you can create a storedprocedure and ask the user to pass the values as parameter.

You can create frontend using VB or ASp etc.