Bill,

If you want to pull data from a view in a specific order, specify an ORDER BY clause in the query that references the view:

USE pubs
GO
CREATE VIEW ca_authors AS
SELECT * FROM authors WHERE state = 'CA'
GO
SELECT * FROM ca_authors ORDER BY au_lname

SQL Server will take your query and combine it with the query that makes up the view. The resultant query will then be executed.

-Mike