This question probably reveals a basic misunderstanding that I have
about client server architecture so please take my confusion into
consideration with your reply.

Is there any way to call a view from a client program and pass
parameters to the server to filter the view before the result of the
view is returned to the client? I know that stored procedures have
paramaters and an ADO recordset can be populated with a parameterized
stored procedure. The recordset is then used as the datasource for
some kind of report as an example.

Instead of using a parameterized stored procedure, is it possible to
achieve the same effect with a view? The answer might be that the
client must retrieve all of the data from the view and then filter it
with criteria on the client. I was wondering if we could cut down on
the data coming across the network by filtering down the view on
server.

Any wisdom on this subject will be greatly appreciated.

John Criswell

[quoted text, click to view]

or a table returning function.