>>>>
>>>>What is your back end? You can do select count(*) first, then the actual select.
>>>
>>>Your suggestion of "count(*) first" is by far faster than select with TOP nnn. I think this should be the solution to the thread but they only allow one. Thank you very much.
>>
>>Do you want MY message to be marked as a solution then <g>? I can do that for you <g>
>
>Sure. Anything to make me happy <g>.
Looks like my screen resolution doesn't allow me to do that. Oh, well, not a big deal anyway <g>
If it's not broken, fix it until it is.
My Blog