Hi Terry,

It was indeed very interesting as an aproach. We tried it but for larger volumes, Our result; the 'between'-statement was 7 times faster (we are running on mssql 2008)

Still any try that can make a faster between I will always look at with interest.

thanks for the demo

best regards

Marcel