>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com