Jim,

The SQL Select will be just as fast as a view, but if you need to modify the resulting record set a view is the way to go.

>Not to argue anything Josh (or JohnK or Dan), but with 35,000 records anything optimizable, including a straight SQL Select, will do nicely here.
>
>Cheers,
>
>jim N
>