|
|
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
Navigation:
[Reply to this message]
|