OT: SQL natural sort question

[Tiemo Hollmann TB]

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130131/10d5df19/attachment.html>