Odd SQL Problem

[Ruslan Zasukhin]

On 2/18/09 8:45 PM, "Beatrix Willius" <bwillius at gmx.de> wrote:

Hi Beatrix,
 
> select mailboxpath, PathSort(MailboxPath) from Mailbox order by 2
> 
> then I get the following result:
> 
> MailboxPath   Value for sorting
> Mailbox:Something 4:Mailbox:Something
> Trash    3:Trash
> Inbox    4:Inbox
> Inbox:Account  4:Inbox:Account
> 
> Am I missing something?

I am not sure that it is possible to sort in such way.

On Table Methods with index it is possible.
But on 
    SELECT expr 

Not remember right now

Ivan?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]