SQL Parameters merged with Cognos Parameters

[Esosa]

Can you merge SQL parameters with COGNOS Parameters to work together? Or how would you adapt the below SQL to work with COGNOS.

Example:
SELECT
  Var1,
  Var2,
  Var3
FROM
  Table_1
WHERE
  ITEM_DT >= TO_DATE(:qDateFrom,'MM/DD/YYYY') AND
  ITEM_DT <= TO_DATE(:qDateTo,'MM/DD/YYYY') AND
   

[Andrei I]

You have to use Macro function Prompt

Example:
Prompt that appends text to the value
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/t_prompt_that_appends_text_relational.html#prompt_that_appends_text_relational