Sorting

[Adrian]

When I sort a number I get a lexicographical sort
1
11
112
1
12
How can I code a sort that will produce
a proper numerical order?

Adrian.

 

[Miha Markic [MVP C#]]

Hi Adrian,

Why don't you set column's DataType to a numeric one (I guess you have it
set to string now).

 

[Adrian]

Why don't you set column's DataType to a numeric one (I guess you have it

set to string now).

Miha,

Yes, but more generally I was looking for an expression like
VALUE([column name]) in a SQL command line.

Adrian.

 

[Miha Markic [MVP C#]]

Hi,

So you want to do sorting on database. What database?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Why don't you set column's DataType to a numeric one (I guess you have it
set to string now).

Miha,

Yes, but more generally I was looking for an expression like
VALUE([column name]) in a SQL command line.

Adrian.

 

[Adrian]

So you want to do sorting on database. What

database?

SqlServer 2005 Express

 

[mcw8]

When I sort a number

Youre sorting text, not numbers. It matters little to the computer that
the text is composed entirely of numeric characters - it's text, not a
number

How can I code a sort that will produce
a proper numerical order?

Use numbers, not text

 

[Miha Markic [MVP C#]]

You might use cast or convert function and sort on the result, something
like ... order by case(comecolumn as int)

 

[Adrian]

You might use cast or convert function and sort on the result, something

like ... order by case(comecolumn as int)

Great. Thank you.

Adrian

 

[Adrian]

Use numbers, not text

Yes, I have changed the code.
Thanks,

Adrian.