Yes. You cannot expect any order to the data unless you use an ORDER BY clause
>Is it normal that from ASP.NET, using the SQL Client data provider, that a select command might return the records in a different order than when the command is executed in SSMS?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer