Hi Borislav

>Try this and you will see the difference:

So if iSID stays constant then it is shot, luckily if I recall correctly (old code) iSID is the PK for the records cBk, iNo So if cBk, iNo combination will change so will iSID

>In SPT (if you ask for data from SQL Server or any other RDB) you have seen the new behaviuor already. Because in all RDBMS you always must put ALL non agregate fields in GROUP BY.

Oh, I was not aware of that, then it is definately good I start writing with EB=90 in mind.

Thanks a lot.