Posted by Robert Klemme on 09/26/05 18:13

Rick wrote:
> I've created a clustered two column index on a table where the second
> column is an integer value. When the first column is the same,
> instead of ordering in numerical order it is ordering
> 1,10,100,2,20,200 etc. How can I change the behaviour to order the
> data in numerical order?

Did you actually declare the second column to be of type int or is it a
varchar and values represent integers? If it's the latter then I wouldn't
be surprised...

robert

[Back to original message]