Re: a sorting conundrum

>>>>> "Dimitre" == Dimitre Novatchev <dnovatchev@xxxxxxxxx> writes:

    Dimitre> If we want to have a more efficient variant of the above,
    Dimitre> which avoids the translate(), (and we assume an
    Dimitre> intelligent optimizer),

    Dimitre> then the following should be much more efficient:


    Dimitre> substring(., string-length(substring-before(.,' ')) +
    Dimitre> (string-length(substring-before(.,' ')) > 0) )

You can remove that assumption of an intelligent optimizer, by placing
the common sub-expression into a variable.
-- 
Colin Paul Adams
Preston Lancashire