Simon Davies wrote:
> If your data is in an integer column then an order by on the data
> column gives what you ask for:
>
SNIP
> sqlite> select data from tst2 order by case cast( data as integer
> )=data when 1 then cast( data as integer ) else data end;
> 1
> 4
> 9
> 10
> 51
> a
Thanks very m
2009/2/23 John Elrick :
.
.
.
>
> The problem: Is there any existing collation solution that respects
> numeric values intermixed with alpha? As an example, if we have the
> following rows:
>
> 1
> a
> 10
> 4
> 51
> 9
>
> traditional alpha-numeric sorting would sort them as follows:
>
> 1
> 10
> 4
I understand this problem can be solved with a custom collation,
however, if at all possible I'd prefer to not reinvent the wheel. I was
curious if there were any pre-existing solutions my Google searches and
reading of the documentation failed to detect.
The problem: Is there any existing col
3 matches
Mail list logo
