How to pass a Prompt Parameter to the SQL Query

[matteo]

Good morning All,

I need to pass a parameter (inserted from the user in the Prompt page) to the SQL Query.

I do an example:

Parameter:
field1=?WORK_ORDER?

Query:
SELECT field1, field2
FROM MyTable
WHERE field1 =?WORK_ORDER?

Is this the right syntax???

Thanks so much.

Regards.

Matteo