Hi,

I have a parameterized view.

For ex: my view looks like this

SELECT *;
FROM my_table;
WHERE a like ?valuea;
AND b = ?valueb;
AND c like ?valuec;
ORDER BY a

If one of the records in the table has nulls in field c, those records are not returned. Why doesn't it bring those records? Does anybody know why?

Thanks
Prashanthi