>In VFP - I have lot's of local views along the line of:
>
> "Select foo from mtable where &cWhere".
>

You can't implement anything like that using a SQL Server view. The best way to get that type of functionality is using SPT.

r = SQLEXEC(hConn, [Select foo from mtable where ] + cWhere, 'result set')

Which will work fine. If you want the user to be able to update, you'll have to do a little more work but you'll still get the flexibility that you're looking for.

-Mike