On 13.05.2007 17:19 CE(S)T, Chris Wedgwood wrote: > On Sun, May 13, 2007 at 05:07:16PM +0200, Yves Goergen wrote: > >> Ah, now I realised that I'd also like to have that "natural sorting", >> meaning this: >> >> 2 >> 8 >> 9 >> 10 >> 11 >> 23 > > select from <col> from table order by cast(<col> as text);
I'm not sure what you wanted to say with this. I removed the first "from" to make it work but it does the same as without the cast. It still sorts strings beginning with "10" before those beginning with "2". -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> Visit my web laboratory at http://beta.unclassified.de ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
