>>>Bad solution indeed.
>>
>>Yes but it worked - how can it be bad?
>>
>>Thanks
>
>If it worked on a small dataset, it would be a dreadful performance on a bigger dataset. You should stay away from SET FILTER command, but if you insist on using it, then try to use the expression matching your index. Say, create an index on ttod(dateTimeColumn) and use it to compare with the date.
Thanks for that - it was a large dataset but I only needed it for a browse of the file and it worked fine
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing