Hi Josh,

One more question regarding this. When I try to put an 'OR' clause for my view in the view designer, it puts for the whole table.

ie

SELECT *;
FROM STARS.REQUEST Request;
WHERE a = ?valuea;
AND b = ?valueb;
AND c = ?valuec
OR c is null;

I want it to be

SELECT *;
FROM STARS.REQUEST Request;
WHERE a = ?valuea;
AND b = ?valueb;
AND (c = ?valuec or c is null);

How can I create the view like this in the view designer?. I know that you can get around this problem by creating the view programmatically.

Thank You