Looking at this part


lu_key IN ;
(SELECT CTOBIN(RIGHT(MAX(DTOS(item_date )+BINTOC(lu_key )),4)) ;

I'm trying to figure out in which order the processing takes place so I can understand the logic behind it. The 2 fields are concatenated, then you find the max aggregate, retrieve the last 4 char and convert to binary which will compare to the "lu_key IN" statement.

Is that correct? My main question is: How can you do a comparison on 2 separate fields that are combined? I never knew you could do that.

Thanks,

Marcel