Is it possible to use a prompt value in a tabular sql

Cognos 8 Business Intelligence Report Studio
1

How do I create an sql statement in a tabular sql where I can use prompt values to select data.

something like:
Select * from database.table
where fieldA = ?promptvalue?

And then I can fill in the promptvalue on the prompt page of the report.
We are on ReportNet version 1.1

2

try this

SELECT * FROM Table1 WHERE Field1=#prompt(“Parameter1”)#

3

Hello Martijn,

Thanks, that was what I was looking for!
Got it working now.

Eric