Re: [Help] How to sort like this with SQL?

>
> SELECT Work_Item
> FROM Work_Table
> ORDER BY Work_Item;
> ...
> 1
> 1.1
> 1.2
> 1.3
> 1.4
> 1.5
> 1.10
> 1.11
> 1.12
> ...
>
> How can I get this result? Please be help!

How about this:

select trunc(Work_Item) || (Work_Item - trunc(Work_Item)) "Work_Item" from Work_Table
order by 1;

> Thanks in advance.

Hope that helps.

Omri. Received on Sun Jan 21 1996 - 22:04:28 CST