>I have several view definitions where I'd like to return either a single record, or a group of them(all in some cases), so I can run the same reports and actions against the one/many without creating two versions of everything. Right now, this is accomplished with a WHERE clause of IIF(EMPTY(?vp_PrimaryKey), .T., Table.PrimaryKey = ?vp_PrimaryKey) . The IIF and EMPTY aren't optimizable - is there a better way to do this that is?

Chris,

This is slightly different approach

WHERE (?vp_PK IS NULL or Table.PK = ?vp_PK)