Okay, I see your point. But I'm still biased in favor of using a view *grin*
>>Again, going back to the original question, he asked if a view would be faster. I threw in parameterized for free, but also mentioned query (referring to a SELECT) statement.
>
>Yep, but the solution is quite different : have an index;
>
>Now is it really so that for future we all should have views in order to make things faster ? Oh, for not too large files maybe ?
>
>He was having a response of 1-2 seconds on a "skip" with his filter. Have an index and the response will be 0,01 (when other environmental things are right); Maybe the view could make it faster, but I won't do the effort.
>
>No offence ment and no offence taken.
Steve Gibson