>>Well, in Oracle it would be done like this:
>>
>>CREATE OR REPLACE VIEW MyView (ParaVar IN SomeTable.Field1%TYPE)
>>IS
>>SELECT Field1, Field2
>> FROM SomeTable
>> WHERE Field1 = Paravar;
>>
>>where paravar is the parameter you want to pass into the view. In SQL Server, I haven't the slightest idea.
>
>Hi Gregg!
>Actually I remember Oracle doing this, I was out to compare SQL Server Views to Oracle Views.
>
>From as far as I can tell, the only way to simulate what we're used to with parameterized VFP views in SQL Server is with a Stored Proc called via SPT

Hi Roxanne,

I have a lot of studying to do to get ready for this. Do you have any books that you'd recommend for studying SQL Server? I need to send off for their time delimited version of SQL Server so I can get some hands-on time with the product. A fellow at our VFP users group in Kansas City said he was able to pass the SQL Server test (but just barely) after a measure of "book larnin" without ever having developed anything with it. I'd rather get into it a little deeper than that. Have you built anything using an SQL Server back end?

Ciao,

Gregg