Hi Bruno,

on MSQL2000 you can use UDF views and tables.
These are parameter view, and are more powerfull of the VFP view.

Example:
FUNCTION fnView (parameters)
RETURNS TABLE
RETURN SELECT .... parameters

or more complex

FUNCTION fnTable (parameters)
RETURNS @varTable TABLE (...)
BEGIN
code for build @varTable
RETURN
END

Fabio