I have a database in MSSQL Server 7.0. I have a table in one of the database. When I give the select statement in the table with particular column as a reference column, each time I am getting in different sort order. What should I do to get the same kind of result?

The table doesn't have any index built based on that particular column. And that particular column allows duplicate values.

Can you please help me in this regard ASAP????

Thanks, Rajkumar.

-- Rajkumar (rajkumar@chn.cognizant.com), February 21, 2002