Hi

Im trying to pass a user entered parameter to the WHERE clause of my SQL QUERY statement, can someone tell me how to do this?

For example, instead of the date entered below , I wish for "'20071010'" to be a user prompted value. How would I do this?

SELECT
SALES_HISTORY_DETAIL."SHD_DESCRIPTION",
FROM
SALES_HISTORY_DETAIL
WHERE
SALES_HISTORY_DETAIL.INVOICE_DATE = "20071010"


Thanks!