Adrian wrote:

> When I sort a number

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

"Adrian" <00@00.00> wrote in message
news:44f6b47e$0$734$5fc3050@dreader2.news.tiscali.nl...
> 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.
>
>

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

"Adrian" <00@00.00> wrote in message
news:44f6c47f$0$748$5fc3050@dreader2.news.tiscali.nl...
>> 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.
>
>

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

"Adrian" <00@00.00> wrote in message
news:44f6d1a5$0$738$5fc3050@dreader2.news.tiscali.nl...
>> So you want to do sorting on database. What
>> database?
>
> SqlServer 2005 Express
>
>

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

> Use numbers, not text