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