And why would you???

Who's going to look at 1,000,000 records? On screen or in print?

Database 101 - only pull what you need and no more...

+++ Rick ---

>>Just benchmark retrieving 1 million records from SQL server and you'd stop there...
>>
>>Not to speak for Rod, but my guess is that he's talking about retrieving a subset, not the entire thing...
>>
>>Kevin
>
>Should be. From his words 'after retrieving...' I sensed he meant it. VFP can do that but .Net:(
>Cetin