Hi all.
I have a query that uses variables, something like this

SQL Query
SELECT *
FROM
MYTAB A
WHERE
A.COL1 = :COL1
AND
A.COL2 = :COL2

However the variables could be null and in that case the query will never return any results.
How can I make it work?