OT: SQL natural sort question

[Ruslan Zasukhin]

On 1/31/13 11:35 AM, "Tiemo Hollmann TB" <toolbook at kestner.de> wrote:

> Hello,
> perhaps somebody can give me a pointer. I have a text field with alphabetic
> (including diacritical chars) and numeric content where I do an ordered
> select. I could do the wanted ³natural sort² by program after the select, but
> I wonder if there is a more straight forward (and faster) way by Valentina /
> SQL without creating sql functions and stuff like this.
> Thanks
> Tiemo

Hi Tiemo,

Example of at least 5-10 records could help understand better what you mean.



-- 
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]