>I tested it in SQL Select. Why would you use two steps if it can be done in one?

I already had two selects in the original program, that's why my solution is acceptable. Otherwise I would use your suggestion.

After second thought, I think, you're right. I'll make this change tomorrow.

Thanks again.

>>>Following will return empty date if there are no records with DeedType = "LC", just tested.

NVL(MIN(IIF(DeedType = "LC", date, Null)), {}) AS  MinLCActDate,

>>
>>Did you test it in SQL or just the command? Anyway, I already used two selects, so I leave min(iif(deetype='LC',date,{^3000-01-01})) and in the second select replace {^3000-01-01} with {}
>>
>< snip >