>Hello everyone:
>
>I ran into a problem in the Enterprise Manager of SQL Server (6.5). When I created a view, I typed in an "order by " statement, to simply sort a column in ascending order, and SQL wouldn't take it!
>
>does anyone know why?
>
>TIA
>jason

An order by clause is normally as simple as:

SELECT Field1, Field2, Field3
FROM Table1
ORDER BY Field1

Could you post your query here so that we can pinpoint the problem.