Using DB2. Is there a way that an SQL SELECT statement WHERE clause can prompt the user for a value to enter? Looking to have the statement ask for the field value, then use it to process the SELECT. If anyone is familiar with the UniVerse (U2 by IBM) database, it allows you to set up inline prompting for it's LIST/SELECT statements. I want to do something similar. I'm guessing though I may have to resort to coding it in. Thanks.